Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Frequency for Histograms in Excel | Charts and Charting in Excel | |||
Determine Frequency in Filtered List | Excel Worksheet Functions | |||
percent frequency | New Users to Excel | |||
Cumulative Frequency | Charts and Charting in Excel |