Get a cell to display the name of a filter selection choice??

[TGill]

Excel 2013. Have a filter created on selected cells (A1:D10), options in column B are 'ABC', 'DEF' & 'GHI". When I filter column B by 'ABC', only the rows with 'ABC' are displayed. NOW, is there a way to have a cell outside of the filtered cells, say K2, to "equal" or display the filter selection, in this case 'ABC'? Obviously, I want this cell (K2) to change/update it's value every time I change the filter selection.

I've spent a while searching, to no avail. Maybe I'm missing something obvious or not using the correct combination of terms.

Thanks in advance for your assistance.

 

[John_w]

Try the method at https://www.mrexcel.com/forum/excel-questions/347226-display-filter-selection.html#post1714607 with the formula =filtercrit(B2) in G1 (a cell on row 1).

 

[TGill]

Thanks, works well enough. The resulting cell is placing an "=" before the filter result, but it's still usable. Thanks again.

 

[John_w]

To fix that change the last line to:

    FilterCrit = Replace(Filter, "=", "")

 

[TGill]

Perfect! Thanks again for the help!