I have a row of data in which cell 'A' is having item code which is
repeating. what i need is to count each items.For eg.
A
1 2354
2 2333
4 2338
5 2354
6 2354
7 2338

I want the count for each item in another sheet like

2354 3
2333 1
2338 2

I don't wan to use subtotal. I have got five different item numbers

Can someone help me for this...
Thanks
Toms


--
SMILE
------------------------------------------------------------------------
SMILE's Profile: http://www.excelforum.com/member.php...fo&userid=4880
View this thread: http://www.excelforum.com/showthread...hreadid=471060