Is that one column for the number, and one for the description, or many for
the description?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"spydor" wrote in
message ...

I am trying to count a data group and return the quanity of unique
entries:
It might look like this:

The data would be in cols & rows

2 green widgets 25.5 inches long
3 green widgets 28.3 inches long
1 brown widgets 52.1 inches long
2 green widgets 25.5 inches long
1 brown widgets 52.1 inches long

the result would be:

4 green widgets 25.5 inches long
3 green widgets 28.3 inches long
2 brown widgets 52.1 inches long

Any simple straight forward way to do this???
Thanks,
Spydor


--
spydor
------------------------------------------------------------------------
spydor's Profile:
http://www.excelforum.com/member.php...o&userid=28438
View this thread: http://www.excelforum.com/showthread...hreadid=482482