Using Excel 2000</SPAN></SPAN>
Hi,</SPAN></SPAN>
My data are in the column C:P, require results in the Column V:X</SPAN></SPAN>
For example count max occurrences of the "last to first" character find in the each row</SPAN></SPAN>
Row 6 last to first character "1" max occurrence=1, result In V6=1</SPAN></SPAN>
Row 7 last to first character X max occurrence=4, result In W7=4</SPAN></SPAN>
Row 8 last to first character 1 max occurrence=13, result In V8=13</SPAN></SPAN>
Row 9 last to first character 2 max occurrence=7, result In X9=7,and so on... </SPAN></SPAN>
Please need to highlight the columns C:P as long as max continue fine "last to first" as shown, 1 with red fills, X with green fills, and 2 with blue fills</SPAN></SPAN>
Example data....</SPAN></SPAN>
Thank you in advance</SPAN></SPAN>
Regards,</SPAN></SPAN>
Kishan</SPAN></SPAN>
Hi,</SPAN></SPAN>
My data are in the column C:P, require results in the Column V:X</SPAN></SPAN>
For example count max occurrences of the "last to first" character find in the each row</SPAN></SPAN>
Row 6 last to first character "1" max occurrence=1, result In V6=1</SPAN></SPAN>
Row 7 last to first character X max occurrence=4, result In W7=4</SPAN></SPAN>
Row 8 last to first character 1 max occurrence=13, result In V8=13</SPAN></SPAN>
Row 9 last to first character 2 max occurrence=7, result In X9=7,and so on... </SPAN></SPAN>
Please need to highlight the columns C:P as long as max continue fine "last to first" as shown, 1 with red fills, X with green fills, and 2 with blue fills</SPAN></SPAN>
Example data....</SPAN></SPAN>
Book1 | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |||
1 | ||||||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||||
3 | ||||||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||||
5 | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | P13 | P14 | 1 | X | 2 | |||||||||||
6 | X | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 2 | X | 1 | 1 | X | 1 | 1 | 0 | 0 | |||||||||||
7 | X | X | 2 | 1 | X | X | 1 | 1 | 2 | 1 | X | X | X | X | 0 | 4 | 0 | |||||||||||
8 | X | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 13 | 0 | 0 | |||||||||||
9 | 2 | 2 | 2 | 2 | 2 | 1 | X | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 7 | |||||||||||
10 | 1 | X | 1 | X | 1 | 1 | 2 | 1 | 1 | X | X | X | 1 | 1 | 2 | 0 | 0 | |||||||||||
11 | X | 2 | X | X | 2 | X | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 0 | 0 | 1 | |||||||||||
12 | X | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 1 | X | 1 | X | 1 | 1 | 0 | 0 | |||||||||||
13 | 1 | X | X | 2 | 1 | X | 1 | 1 | 1 | 2 | 1 | 1 | X | 1 | 1 | 0 | 0 | |||||||||||
14 | 1 | 1 | 1 | 2 | X | X | X | 1 | X | X | 1 | X | X | X | 0 | 3 | 0 | |||||||||||
15 | 1 | X | X | 1 | 1 | 1 | 1 | 1 | X | 1 | 1 | 2 | X | 1 | 1 | 0 | 0 | |||||||||||
16 | X | 1 | X | 2 | 1 | 2 | X | X | X | 1 | 1 | 1 | X | X | 0 | 2 | 0 | |||||||||||
17 | 1 | 1 | X | 1 | 2 | 1 | X | 1 | 1 | 1 | 2 | 1 | X | 1 | 1 | 0 | 0 | |||||||||||
18 | 1 | 1 | 1 | 1 | 1 | X | 1 | 1 | 1 | 2 | 2 | X | 1 | 1 | 2 | 0 | 0 | |||||||||||
19 | X | X | X | X | X | X | X | X | X | X | X | 1 | X | X | 0 | 2 | 0 | |||||||||||
20 | 1 | 1 | 1 | 1 | 2 | 1 | X | X | 1 | 2 | X | 1 | X | 2 | 0 | 0 | 1 | |||||||||||
21 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | X | 1 | 2 | 1 | 1 | X | 1 | 1 | 0 | 0 | |||||||||||
22 | 2 | 1 | X | 1 | 1 | X | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 0 | 0 | 1 | |||||||||||
23 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | X | X | 1 | 1 | 0 | 0 | |||||||||||
24 | X | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | X | 1 | 1 | 1 | X | 0 | 1 | 0 | |||||||||||
25 | 1 | 1 | 1 | 1 | X | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 9 | 0 | 0 | |||||||||||
26 | X | 1 | 1 | 1 | 1 | 2 | 1 | 1 | X | X | 1 | 1 | X | 1 | 1 | 0 | 0 | |||||||||||
27 | 1 | 2 | X | X | X | X | 1 | 2 | 1 | 1 | 1 | X | 1 | 1 | 2 | 0 | 0 | |||||||||||
28 | 1 | 1 | 1 | 2 | 1 | 2 | X | X | X | X | 1 | X | 1 | X | 0 | 1 | 0 | |||||||||||
29 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | X | 1 | 2 | 1 | X | 2 | 0 | 0 | 1 | |||||||||||
30 | 1 | 1 | 1 | X | 1 | 1 | 1 | X | 1 | 1 | X | 1 | 1 | 2 | 0 | 0 | 1 | |||||||||||
31 | 1 | 1 | 1 | X | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 0 | 0 | |||||||||||
32 | 1 | X | 1 | 1 | 2 | 1 | 1 | X | X | X | 1 | X | 2 | 1 | 1 | 0 | 0 | |||||||||||
33 | 2 | 2 | 1 | 1 | X | 1 | X | 2 | 1 | 2 | 2 | 1 | X | 1 | 1 | 0 | 0 | |||||||||||
34 | 1 | X | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | X | 1 | X | 1 | 1 | 0 | 0 | |||||||||||
35 | 2 | 2 | 2 | 1 | 2 | X | 1 | X | X | 1 | 1 | X | X | 1 | 1 | 0 | 0 | |||||||||||
36 | 1 | X | X | 2 | 1 | 1 | 2 | X | 1 | 1 | X | 1 | 2 | X | 0 | 1 | 0 | |||||||||||
37 | X | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | X | X | X | X | 0 | 1 | 0 | |||||||||||
38 | X | 2 | 1 | 1 | X | X | 1 | 1 | 1 | 2 | X | 1 | 1 | 1 | 3 | 0 | 0 | |||||||||||
39 | X | 1 | 2 | 1 | 2 | 1 | X | X | X | X | X | 1 | 1 | 2 | 0 | 0 | 2 | |||||||||||
40 | 1 | 1 | 1 | X | X | 1 | 2 | X | 1 | 2 | 1 | X | X | 1 | 1 | 0 | 0 | |||||||||||
41 | X | X | X | 1 | 1 | X | 1 | 1 | 1 | 1 | X | X | 1 | 1 | 2 | 0 | 0 | |||||||||||
42 | 2 | X | 2 | 1 | X | 1 | X | 1 | 1 | X | 1 | 2 | 2 | 1 | 1 | 0 | 0 | |||||||||||
43 | X | X | 1 | 2 | X | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | |||||||||||
44 | X | X | 1 | X | 1 | 1 | 1 | 1 | X | 1 | 2 | 1 | 1 | X | 0 | 1 | 0 | |||||||||||
45 | 1 | 1 | X | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | X | 1 | 1 | 2 | 0 | 0 | |||||||||||
46 | 1 | 1 | 1 | 1 | X | 2 | 2 | 1 | 1 | 1 | 1 | 1 | X | 1 | 1 | 0 | 0 | |||||||||||
47 | ||||||||||||||||||||||||||||
48 | ||||||||||||||||||||||||||||
49 | ||||||||||||||||||||||||||||
Sheet5 |
Thank you in advance</SPAN></SPAN>
Regards,</SPAN></SPAN>
Kishan</SPAN></SPAN>
Last edited: