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

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

.

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