Hi
I need to a formula to display any of the weeks total's that are greater than zero and excluding week 5. Is there a way to make a vlookup or an index/match to exclude criteria/data?
Thank You
MZing81
I need to a formula to display any of the weeks total's that are greater than zero and excluding week 5. Is there a way to make a vlookup or an index/match to exclude criteria/data?
PERSON | WEEK | TOTAL |
MRS.TWO | 5 | 20 |
MR.ONE | 5 | 40 |
MR.ONE | 26 | 0 |
MR.THR | 3 | 5 |
MR.THR | 5 | 40 |
MR.R | 5 | 10 |
MR.R | 1 | 3 |
MRS.FOU | 4 | 30 |
MRS.FOU | 5 | 40 |
MR.SEVE | 5 | 40 |
MRS.TEN | 5 | 40 |
MRS.TEN | 20 | 2 |
MR.ELEV | 3 | 4 |
MR.ELEV | 5 | 25 |
MZing81