Counting Occurances of Numbers in Columns

Posted by Tim on February 18, 2001 1:43 AM

Hi,

I have a sheet with 10 columns of numbers, spanning 600
rows. I need to know the number of times each
number occurs in a particular column.
Is there an easy way to do this?

Posted by Dave Hawley on February 18, 2001 3:45 PM

Tim, I would suggest using a simple Pivot Table fo this, found under Data on the Menu bar.

Dave

OzGrid Business Applications