Results 1 to 10 of 10

Cell which displays the filter in use as text

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,702

    Cell which displays the filter in use as text

    Hi,
    I have never seen this before so I don’t know if this is possible or not...

    I require a formula that displays as text the filter criteria which has been applied to a data table.

    For instance as an example in the attached I have applied the following filters:
    Product:
    Energikare and S4
    Spacer:
    Swiss
    Thg/Ann:
    Toughened and Annealed
    Textured?:
    Textured
    Georgian:
    Georgian and No Georgian

    I would there like the following cells to display the following:
    Cell C2: Energikare and S4
    Cell C3: Swiss
    Cell C4: Toughened and Annealed
    Cell C5: Textured
    Cell C6: Georgian and No Georgian

    Basicallly, I would need the cell to display the name if the box is ticked from the drop down filter.
    If all products are ticked I would like it to display All Products rather than EnergiKare and Laminated and Other and S4 and Tripple Glazed.

    I have uploaded an example file, the formula is needed in the yellow cells.

    Can anyone help please?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1