Lowkey -

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. <

(A) COUNTIF function

(B) array-entered FREQUENCY function

(C) Analysis ToolPak Histogram tool (counts and chart)

(D) my Better Histogram add-in from www.treeplan.com

- Mike
www.mikemiddleton.com