Creating a list from multiple (sometimes the same) codes

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have in column A a list of say 100 codes of which many may be duplicated.

I wish to produce in column B an automatic list (produced without further
manual input) using all the different codes in column A

i.e. Answers in column A may be XX12, XX13, XX13, YY45, YY45, YY45, ZZ33 & R45

In column B I want to see a list of items (don't know how they will be
sorted) showing XX12, XX13, YY45, ZZ33 & R45 thus avoiding duplications.

Therefore I don't want to produce a drop down list which requires manual
choices in column B.

How do I do this please?

Thanks
 
If you don't want to use Advanced Filter > filtering Unique Items - you may
consider:
* Start your 100 item list from cell A2 and down.
2) In cell B2 type:
{=INDEX($A$2:$A$101,MATCH(,COUNTIF($B$1:$B1,$A$2:$A$101),))}
and copy down until you get an error.
*** This is an array formula, and is to be confirmed with CTRL+SHIFT+ENTER
rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
“Excelâ€, when the formula is entered as an Array formula.
Micky
 
Back
Top