Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

One way to do this is to use classes in combination with the FREQUENCY() function (help page) in array form. Create a row of classes (perhaps integers from 1-500) via a simple click-n-drag or basic addition formula. The function can then be used to determine how many occurrences of each datum fall within each class. There are other methods using VLOOKUP() and MATCH() functions in array form.