Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
remote functions | Excel Worksheet Functions | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions | |||
How to load Engineering Functions into the Fx function wizard? | Excel Worksheet Functions | |||
Where can I see VBA code for financial functions? | Excel Worksheet Functions |