View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rothman
 
Posts: n/a
Default Frequency Question -- Please Help

I have a grid of numbers.

I want to create a new grid which has corresponding frequencies for the
original grid.

In other words, if A1 = 10, and my data spreads from A1 to G100, then I want
A1 of the new grid to = how many times 10 appears in the A1 to G100 dataset.

Anyone know how to do this without having to create a histogram and manually
matching my numbers with the histogram's frequencies? My dataset is becoming
too large to do all that matching (and I make errors after my eyes go buggy).