I had to retype everything into Excel your picture shows. Please provide next time your sample yourself in an Excel readable form.
Book1 |
---|
|
---|
| B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R |
---|
2 | | | | 19-Nov-18 | | | | name | | | | | | | | | |
---|
3 | | | | 24-Nov-18 | | | | george | | | | | | | | | |
---|
4 | | | | | | | | paul | | | | | | | | | |
---|
5 | | | | | | | | drake | | | | | | | | | |
---|
6 | | | | | | | | john | | | | | | | | | |
---|
7 | | | | | | | | | | | | | | | | | |
---|
8 | | 11/19/2018 | 11/20/2018 | 11/21/2018 | 11/22/2018 | 11/23/2018 | 11/24/2018 | 11/25/2018 | 11/26/2018 | 11/27/2018 | 11/28/2018 | 11/29/2018 | 11/30/2018 | 12/1/2018 | 12/2/2018 | 12/3/2018 | 12/4/2018 |
---|
9 | george | 1 | | | | 1 | 1 | 1 | | | | | | | | | |
---|
10 | paul | | | | | | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
---|
11 | drake | 1 | | | | | | | 1 | | 1 | | 1 | | 1 | | |
---|
12 | john | | 1 | 1 | | | 1 | | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | 1 |
---|
13 | kenneth | | | | | | | 1 | | 1 | 1 | 1 | | 1 | | 1 | |
---|
14 | roy | | | | | | | 1 | 1 | | | | | 1 | 1 | 1 | |
---|
|
---|
In I3 control+shift+enter, not just enter, and copy down:
=IFERROR(INDEX($B$9:$B$14,SMALL(IF(FREQUENCY(IF($C$8:$R$8>=$E$2,IF($C$8:$R$8<=$E$3,IF($C$9:$R$14=1,MATCH($B$9:$B$14,$B$9:$B$14,0)))),ROW($B$9:$B$14)-ROW($B$9)+1),ROW($B$9:$B$14)-ROW($B$9)+1),ROWS($1:1))),"")