Lowkey

You can use the frequency function.

With your data range of A1:A10.

Type in 1,2,3 in cells B1:B3.

Select C1:C3 and copy or type this into the active cell.

=FREQUENCY(A1:A10,B1:B3)

This is an array formula so press ctrl+shift+enter.


Gord Dibben Excel MVP


On Tue, 17 May 2005 12:12:09 -0700, Lowkey
wrote:

Is there a function that will find the recurring values within a range and
then count the number of recurrences for those values? For example, if my
range 1,2,1,3,2,1, then 1 = 3 times, 2 = 2 times, and 3 = 1 time. I would
like the results returned so that they can be charted.