Filter Name

[JDM1]

Is it possible to show the selected filter from a column in a separate single cell
that would update with each selected filter selection?

Thanks for any help or idea's

 

[asking]

Check this thread on Mr excel ~

http://www.mrexcel.com/forum/showthread.php?t=331474

Or if you are only filtering by numbers you could do ~
=INDEX(SUBTOTAL(1,Range),1)

Where range is in the formula replace with your range e.g... B2:B500

Cheers