| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| 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 | |||
Linear Mode
