Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Can I add a "filtered by" literal to a cell?

    Dear Loungers.

    I want to be able to have a heading on my spreadsheet which shows the current filter conditions. The results would be something like "filtered by Owner = Helen". I can't find anything that does this, does anyone know any different?

    thank you.......................... liz

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    John Walkenbach's site (http://www.j-walk.com/ss/excel/usertips/tip044.htm) has a routine that Stephen Bullen developed to display the current AutoFilter criteria in a cell. It should be adaptable for your needs.

    Steve

  3. The Following 2 Users Say Thank You to sdckapr For This Useful Post:

    lizat (2011-08-09),suzy (2011-08-07)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •