View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

if data is in column a try
in B1
=countif($A$1:$A$1000,A1) and copy down to end of data. (Change range as
appropriate
You can then plot B vs A
or you could select column A, use <data<filters<advanced filter
Select unique values in location c1
enter
in D1 use
=countif($A$1:$A$1000,C1) and copy down to end of data in C
Plot D vs C
You wont have overlapping data points in this plot.

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