Hi, Is anyone can please help me out with the below?. Please refer to my attachment spreadsheet for sample data.
Apart from using vlookup I am thinking there must be a easier way of how to work this out simpler and quicker.
How to 1: For each record, check if N2, O2, P2, Q2, R2, S2 is within range C2 to L2. If they are, return the value in U2 v2, W2, X2, Y2 and Z2
How to 2: Find a perfect couple, triple and quardruple that most occurred in all records. In this case, perfect couple are 9 and 19 which occurred 3 times, and perfect triple are 9, 19 and 20 which occurred 2 times, and perfect quardruple are 9, 10, 19, 20 and 2, 4, 10, 20.
Thank you all kindly
Hatuau