=Unique Values

[msibley]

I am trying to get Excel to help create a list of unique values. In
column A I have a list of box numbers and in B the contents. For
example:
A B
123 tax returns for 1999
123 tax returns for 2000
124 tax returns for 2001

I need to get a list of the unique box numbers in col A. I can't do a
count as some are duplicated. I am dating myself, but Lotus 123 has a
function of @UNIQUE{range}. Can anyone help?

 

[Peo Sjoblom]

You can use advanced filter, select the box numbers with a header included,
don't expand the selection if prompted
and select copy to another location and unique entries only

or you can use a help formula

use an empty help column and assume the start in A2 then in the help column
(assume we use column D) in D2
put

=INDEX($A$2:$A$500,MATCH(0,COUNTIF($D$11,$A$2:$A$500),0))

enter it with Cmd + Enter (Ctrl + Shift & Enter on PC)

copy down until you get an error

Note that the countif part must use the cell above (in this case D1 since I
assmed we entered utbe formula in D2)