Data Question - list of unique records

J

Joshua

Hi,

I have data and some of the data, names in this case is repeated. There are
about 100 unique names, but as they appear more than once, the list is 300+
rows long.

Is there a formula I can use to get a list of all unique name entries - in
other words, the list of 100 names represented singly, without duplication?
 
Z

Zack Barresse

Hi Joshua,

You can use Data | Advanced Filter.

For a formula approach (assuming your data starts in row 2 and is looking at
column A)...

=COUNTIF($A$2:A2,A2)

Copy down as needed. All of the values which equal 1 are unique. To "tag"
only uniques, nest in an IF function ..

=IF(COUNTIF($A$2:A2,A2)=1,1,"")

HTH
 
S

starguy

I suppose that your data starts from A2 downwards in col A
enter in B2 following formula.
=IF(COUNTIF($A$2:$A$300,A2)>1,IF(ISNA(VLOOKUP(A2,$B$1:B1,1,FALSE)),A2,"-"),A1)
this formula will list out all values only once in col B.
now copy col B and paste special as values in col C and sort col C t
remove blanks.

hope this will help you.
 
Top