formula plese :)

  • Thread starter Thread starter ab500
  • Start date Start date
A

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
 
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)
 
Back
Top