Position | Location 1 | Location 2 | Location 3 | Location 4 | Location 5 | Location 6 |
1 | 1 | 11 | 21 | 31 | 41 | 51 |
2 | 2 | 12 | 22 | 32 | 42 | 52 |
3 | 3 | 13 | 23 | 33 | 43 | 53 |
4 | 4 | 14 | 24 | 34 | 44 | 54 |
5 | 5 | 15 | 25 | 35 | 45 | 55 |
6 | 6 | 16 | 26 | 36 | 46 | 56 |
7 | 7 | 17 | 27 | 37 | 47 | 57 |
8 | 8 | 18 | 28 | 38 | 48 | 58 |
9 | 9 | 19 | 29 | 39 | 49 | 59 |
10 | 10 | 20 | 30 | 40 | 50 | 60 |
I am trying to select a Position '1' if Location selected are in the range of (1,11,21,31,41,51), and same for other Position nos, I have used IF(OR(J15 = {1,11,21,31,41,51}),A15) function but in that range no is fixed. Can anyone help. What if I don't want to give range value manually.