Column A | Column B | Column C | Column D | Column E | COL F | COL G | COL H | COL I | COL J | |
TOM | 23 | 18 | TOM | PHIL | LANCE | RONNIE | LARRY | |||
PHIL | 12 | |||||||||
MIKE | 2 | |||||||||
LARRY | 34 | |||||||||
RONNIE | 43 | |||||||||
LANCE | 4 | |||||||||
TUG | 5 | |||||||||
EMILY | 8 | |||||||||
ASHLEY | 12 |
I have a sheet with data like above but many more entries in column J how would i put in a formula to look the names up that are in columns E through I and based on the data in Col A & B tell me how many of the values (col B) for each person in Col E through I ,is greater than the value in Column D.
Thanks for your time.
Adam