how to assign cell value which the users has filtered by?

This array formula** will return the 1st item from the range D2:D15 when a
filter is applied.

=INDEX(D2:D15,MATCH(1,SUBTOTAL(3,OFFSET(D2:D15,,,R OW(D2:D15)-ROW(D2)+1)),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Aashish" wrote in message
...
how to assign cell value which the users has filtered by?

Please provide more details.

Current description is not clear.

You want to filter a list for a value user has entered in a cell?

Advanced filter see Debra Dalgleish's site.

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben MS Excel MVP

On Wed, 11 Nov 2009 11:56:03 -0800, Aashish
wrote:

how to assign cell value which the users has filtered by?