Hi
I want to little help with this.
I attached an example of my problem and if someone ca give me a working formula i will be really grateful.
here is summary of the problem:
A B C D E F
1 P1 P2 S1 P3 P4 S2
2 a b 26 c d 24
3 c a 23 b d 21
4 b c 21 a d 11
I want to make array when C>=20 and F>=20 it should give players and their scores, result should only give
A B C D E F
6 P1 P2 S1 P3 P4 S2
7 a b 26 c d 24
8 c a 23 b d 21
results from 4th row will not appear because F4 is not greater tan 20.
No macro or vb please. Only formula for excel.
Thank you very much
Workbook1.xlsx
Bookmarks