76chickens
New Member
- Joined
- Apr 27, 2015
- Messages
- 14
Please can anyone help me to make a formula for this sheet? Thanks in advance!
Excel Workbook | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | People who scored | |||||||||
2 | Name | Score | 3 | 4 | 5 | 6 | ||||
3 | Joanna | 4 | Emma | Joanna | step | Vane | ||||
4 | Emma | 3 | Ben | Carol | Simon | |||||
5 | step | 5 | Louise | |||||||
6 | Vane | 6 | ||||||||
7 | Carol | 4 | ||||||||
8 | Ben | 3 | ||||||||
9 | Simon | 5 | ||||||||
10 | Louise | 4 | ||||||||
Hoja7 |
Cell | Formula |
E2 | =IF(D2="",MIN($C$3:$C$10),IF(D2<MAX($C$3:$C$10),D2+1,"")) |
Cell | Array Formula |
E3 | {=IFERROR(INDEX($B$1:$B$10, SMALL(SI($C$3:$C$10=E$2, ROW()), ROW()-2)),"")} |