PLZ HELP, I WANT TO CHECK VALUES FROM CELL A17:E17 IN PREVIOUS CELLS i.e. B7:E16 AND IF THESE VALUES (VALUES IN A17:E17) ARE PRESENT IN SAME SEQUENCE IN PREVIOUS CELLS THEN F1:F20 WILL GIVE CORRESPONDING SERIAL NUMBERS. IF POSSIBLE PLEASE GIVE SOME MARGIN SAY 5% FOR VALUES IN CELLS B7:E16 SO THAT IF EXACT VALUES ARE NOT PRESENT THEN SOME MARGIN CAN BE PROVIDED (IF VALUE DEVIATES LESS THAN 5% FROM REQUIRED VALUE).
| New Microsoft Excel Worksheet.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | ||||||||||||||
| 2 | ||||||||||||||
| 3 | ||||||||||||||
| 4 | ||||||||||||||
| 5 | ||||||||||||||
| 6 | SR.NO. | A | B | C | D | RESULT-1 | RESULT-2 | RESULT-3 | RESULT-4 | RESULT-5 | RESULT-6 | |||
| 7 | 1 | 1 | 2 | 3 | 4 | |||||||||
| 8 | 2 | 5 | 6 | 7 | 8 | |||||||||
| 9 | 3 | 5 | 6 | 5 | 7 | |||||||||
| 10 | 4 | 7 | 4 | 5 | 6 | |||||||||
| 11 | 5 | 1 | 2 | 3 | 4 | |||||||||
| 12 | 6 | 5 | 7 | 8 | 7 | |||||||||
| 13 | 7 | 6 | 8 | 5 | 9 | |||||||||
| 14 | 8 | 1 | 2 | 3 | 4 | |||||||||
| 15 | 9 | 7 | 5 | 6 | 8 | |||||||||
| 16 | 10 | 4 | 5 | 6 | 5 | |||||||||
| 17 | 11 | 1 | 2 | 3 | 4 | 1 | 5 | 8 | ||||||
| 18 | ||||||||||||||
| 19 | ||||||||||||||
| 20 | PLZ HELP, I WANT TO CHECK VALUES FROM CELL A17:E17 IN PREVIOUS CELLS i.e. B7:E16 AND IF THESE VALUES (VALUES IN A17:E17) ARE PRESENT IN SAME SEQUENCE IN PREVIOUS CELLS THEN F1:F20 WILL GIVE CORRESPONDING SERIAL NUMBERS. IF POSSIBLE PLEASE GIVE SOME MARGIN SAY 5% FOR VALUES IN CELLS B7:E16 SO THAT IF EXACT VALUES ARE NOT PRESENT THEN SOME MARGIN CAN BE PROVIDED (IF VALUE DEVIATES LESS THAN 5% FROM REQUIRED VALUE). | |||||||||||||
| 21 | ||||||||||||||
| 22 | ||||||||||||||
| 23 | ||||||||||||||
| 24 | ||||||||||||||
| 25 | ||||||||||||||
Sheet2 | ||||||||||||||
