formula help
 

See Chip Pearson's page on this topic for many ideas:

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy


"Matt" wrote in message
...
Is there a function that is something like "Isunique"? I
am trying to eliminate all duplicate entries into column B
below. The totals to the right are not an issue. I just
want to collect only the unique entries.


DNC =3 +Q 446
=3 +Q 5
=3 +Q 65
=3 +R 307
=3 +R 27
=3 +R 5
=3 +S 113
=3 +S 9
=3 +S 3
=3 =3 23
GJ GJ 92
KU KU 17
RX RX 7
SW SW 3
02 02 12
03 03 1
2K 2K 1,489
22 22 80
23 23 1,258
26 26 121
27 27 1
28 28 1

Thanks in advance.