View Single Post
  #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