formula plese :)

[ab500]

Ok, if any of you guys can help that'd be great. I have a rather large
column thats full of different model numbers. I want to be able to list
each unique model number and how many times it appears in the list. The
model numbers are combinations of numbers and text. Any help would be
awesome.

Thanks in advance

 

[JE McGimpsey]

A pivot table would be ideal:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[Ninja Stevie]

Or you could use the advanced filter, selecting the option to copy list
to another location, and ticking the 'unique items only' option. Then
use the =countif() formula on the filtered list. ('Help' will tell you
more about these functions if you're not sure how to implement them)