LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
remote functions rob1234 Excel Worksheet Functions 1 May 12th 05 06:18 PM
3 questions about automated c++ com add-in worksheet functions gert Excel Worksheet Functions 0 March 10th 05 09:57 AM
# of Functions per cell SUB-ZERO Excel Worksheet Functions 3 January 23rd 05 10:35 PM
How to load Engineering Functions into the Fx function wizard? jsaval Excel Worksheet Functions 1 November 11th 04 09:47 PM
Where can I see VBA code for financial functions? eios Excel Worksheet Functions 1 November 2nd 04 01:00 PM


All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"