View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
 
Posts: n/a
Default Have column of nums, need qty of each?

Hi

Create a pivot table based on column (as field in pivot table). In pivot
layout sheet, set row=field, and data=(count of field ). Its all.


Arvi Laanemets


"samckitt" wrote in
message ...

I have a column of a couple of thousands of numbers and I need a quick
easy way to figure the qty of each number in the column. Is there an
easy way to do this in Excel?
Thanks,
Scot


--
samckitt
------------------------------------------------------------------------
samckitt's Profile:

http://www.excelforum.com/member.php...o&userid=33089
View this thread: http://www.excelforum.com/showthread...hreadid=528989