ExcelBanter - Lookup for once

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Lookup for once (https://www.excelbanter.com/excel-discussion-misc-queries/17386-lookup-once.html)

Kevin Lin

Lookup for once

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

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

All times are GMT +1. The time now is 07:24 PM.