LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mac_see
 
Posts: n/a
Default Finding frequency

B2:R2 has
1-Feb 2-Feb 3-Feb 4-Feb 5-Feb 6-Feb 7-Feb 8-Feb 9-Feb 10-Feb Dick Grace Harry Maxi Renny Tim Tom

A3:R3 has
Test1 Tom Dick Tom Maxi Tom Dick Dick Harry Tim Tom 0 N/A N/A N/A N/A N/A 1

A4:R4 has
Test2 Dick Maxi Maxi Grace Renny Renny Tom Harry Dick Tom 7 N/A N/A 0 0 N/A 0


I am looking out formula for range L3:R4

There are two tests happening for 7 participants.
The one who tops the test, his name is displayed below that date. I want to
check the minimum difference for the toppers.

Eg. Dick topped the test1 thrice (on 2nd 6th and 7th) Out of these three, he
topped on two consecutive days, hence the difference is 0. This should be
displayed in cell L3

Similarly, Tom topped 4 times but on two occassions, he topped on the
alternate days hence the value for him is 1.

Maxi
 
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
Frequency for Histograms in Excel Jim Charts and Charting in Excel 7 February 24th 05 07:33 PM
Determine Frequency in Filtered List Michael Excel Worksheet Functions 3 February 10th 05 07:57 PM
percent frequency new excel user New Users to Excel 2 February 6th 05 09:53 PM
Cumulative Frequency Chris Grant Charts and Charting in Excel 2 February 3rd 05 05:49 AM


All times are GMT +1. The time now is 06:32 PM.

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"