referencing autofilter result
 

I need to have a cell display the value of a cell selected in an
autofilter (it will always show only 1 result). My list (autofiltered)
has only 1 column.
Thanks


--
EH003268
------------------------------------------------------------------------
EH003268's Profile: http://www.excelforum.com/member.php...o&userid=11806
View this thread: http://www.excelforum.com/showthread...hreadid=398545

If it's a column of numbers, you could use the Subtotal function to show
the selected cell. For example, with your list in column A:

=SUBTOTAL(9,A:A)

EH003268 wrote:
I need to have a cell display the value of a cell selected in an
autofilter (it will always show only 1 result). My list (autofiltered)
has only 1 column.
Thanks




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks for the reply but
My list is text only. i want to use the selected cell for a vlookup in
another worksheet.


--
EH003268
------------------------------------------------------------------------
EH003268's Profile: http://www.excelforum.com/member.php...o&userid=11806
View this thread: http://www.excelforum.com/showthread...hreadid=398545