Lookup for once

K

Kevin Lin

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
 
B

Biff

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
 
D

Domenic

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!
 
Top