Hello To All,</SPAN></SPAN>
Is it possible if I select the row 14, range A14:E14 and get highlighted all matched numbers are in columns as shown in example below.</SPAN>
<TBODY>
</TBODY>
Thanks In Advance,</SPAN></SPAN>
Kishan</SPAN></SPAN>
Is it possible if I select the row 14, range A14:E14 and get highlighted all matched numbers are in columns as shown in example below.</SPAN>
A | B | C | D | E | |
1 | 6 | 27 | 30 | 36 | 43 |
2 | 4 | 5 | 15 | 19 | 41 |
3 | 3 | 30 | 39 | 40 | 41 |
4 | 3 | 21 | 34 | 38 | 48 |
5 | 28 | 13 | 17 | 38 | 44 |
6 | 2 | 11 | 13 | 26 | 50 |
7 | 13 | 29 | 43 | 47 | 50 |
8 | 16 | 31 | 32 | 37 | 41 |
9 | 12 | 22 | 35 | 46 | 49 |
10 | 8 | 15 | 17 | 25 | 28 |
11 | 2 | 4 | 30 | 26 | 36 |
12 | 13 | 34 | 37 | 47 | 49 |
13 | 5 | 11 | 22 | 34 | 40 |
14 | 8 | 15 | 26 | 30 | 48 |
<TBODY>
</TBODY>
Thanks In Advance,</SPAN></SPAN>
Kishan</SPAN></SPAN>