See this:

http://tinyurl.com/2885hu

--
Biff
Microsoft Excel MVP


"RBG" wrote in message
...
I am trying to create a formula, say in cell B1 that would return the same
info that is returned from my filter. For example if i filter my data on
colors and I return a 'red' result, I would like cell B2 to read 'Colors -
Red'