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