You want Unique records, yes?
You can try this:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"mallets123" wrote
in message ...

Is there a function which will count in a range of cells (text, i.e.
state abbreviations) each time a new state abbreviation occurs?

Thanks for any help with this, going crazy here...


--
mallets123
------------------------------------------------------------------------
mallets123's Profile:
http://www.excelforum.com/member.php...o&userid=25090
View this thread: http://www.excelforum.com/showthread...hreadid=386023