Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup for once
Thanks Dave for your help.
But is there a way that you could input a formula instead of having the advanced filter? Thank you, Kevin ------------------------------------------------------ Maybe Data|Filter|Advanced filter|Unique Records only. See Debra Dalgleish's site for nice instructions. http://contextures.com/xladvfilter01.html#FilterUR Kevin Lin wrote: Hi All, Need help on the following. A V 1 AAA001 AAA001 2 AAA001 BBB001 3 AAA001 BBB002 4 BBB001 5 BBB001 6 BBB002 I need a formula in column V that could auto pick-up or lookup what was inputed in column A and without repeating in column V. Thank you, Kevin -- Dave Peterson |
#2
|
|||
|
|||
Hi!
In cell V2 (leave cell V1 empty) enter this formula with the key combo of CTRL,SHIFT,ENTER: =IF(ISNA(MATCH(0,COUNTIF($V$1:V1,$A$1:$A$6),0)),"" ,INDEX (A$1:A$6,MATCH(0,COUNTIF($V$1:V1,$A$1:$A$6),0))) Copy down as needed. Biff -----Original Message----- Thanks Dave for your help. But is there a way that you could input a formula instead of having the advanced filter? Thank you, Kevin ------------------------------------------------------ Maybe Data|Filter|Advanced filter|Unique Records only. See Debra Dalgleish's site for nice instructions. http://contextures.com/xladvfilter01.html#FilterUR Kevin Lin wrote: Hi All, Need help on the following. A V 1 AAA001 AAA001 2 AAA001 BBB001 3 AAA001 BBB002 4 BBB001 5 BBB001 6 BBB002 I need a formula in column V that could auto pick-up or lookup what was inputed in column A and without repeating in column V. Thank you, Kevin -- Dave Peterson . |
#3
|
|||
|
|||
With cell V1 empty, enter the following formula in V2 and copy down
until you get #N/A: =INDEX(A1:$A$7,MATCH(0,COUNTIF($V$1:V1,A1:$A$7),0) ) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "Kevin Lin" wrote: Thanks Dave for your help. But is there a way that you could input a formula instead of having the advanced filter? Thank you, Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Lookup Lookup | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |