Try this array formula** :

Assume row 1 is the column header with filter.

A2:A15 is the actual data range.

=INDEX(A2:A15,MATCH(1,(SUBTOTAL(3,OFFSET(A2:A15,RO W(A2:A15)-MIN(ROW(A2:A15)),0,1)))*(A2:A15<""),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Sal" wrote in message
...
I haven't figured out how to return the filtered value into a specific
cell.
I have a large spreadsheet where I filter 3 specific columns and I need
those
3 specific filtered values (which are text) to be display in a different
area
of the same spreadsheet in a specific cell. It think it may be similar to
the subtotal function which only adds the filtered values
=subtotal(9,Range)
but I've been searching only with no success yet. Thanks.