View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kevin20142000@yahoo.com is offline
external usenet poster
 
Posts: 1
Default count frequency in excel

I have a large number of numerical data (500) on column A of excel. I
would like to count frequency of all unique number. For example:

2
2
5
7
2
300
freq. 2 is 3
5 is 1
7 is 1
300 is 1

Since the number is large, I probably could not identify all unique,
or min, or max number.

Could anyone give a help?

Thanks,