Counting entries, ignore duplicates

[protest_boy]

Suppose I have a list like so:

ZC00661
ZC00662
ZC00663
ZC00663
ZC00664

Is there a way to count the number of unique entries ignoring the duplicate ZC00663? OR, a way to delete the duplicates? Then counting is easy by looking at the line number?

I'm fairly new to excel so please be explicit when responding. Thanks so much!

 

[Brian from Maui]

Try this thread

http://www.mrexcel.com/board/viewtopic.php?topic=8659&forum=2

 

[excelforrockets]

Use a pivot table.... pivot the data against itself

 

[Aladin Akyurek]

On 2002-08-26 10:24, Brian from Maui wrote:
Try this thread

http://www.mrexcel.com/board/viewtopic.php?topic=8659&forum=2

... and this thread for counting:

http://www.mrexcel.com/board/viewtopic.php?topic=19298&forum=2

 

[protest_boy]

Ahh, thank you all! That will save me oodles of time!