Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to .. | Excel Discussion (Misc queries) | |||
excel | Excel Worksheet Functions | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) |