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

I think the entire design in messed up. Let me put this question again.

[Data in B2:R2]
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

[Data in A3:R3]
Test1 Tom Dick Tom Maxi Tom Dick Dick Harry Tim Tom 0 N/A N/A N/A N/A N/A 1

[Data in A4:R4]
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