Spreadsheet: 55093d1255184655-search-vertical-diagonal-question-excel-search
Sheet: Blad7

5555 | 5555 | 5555 | 5555 | 5555 | 5555 | 5555 | 5555 | 5555 | 5555 | 5555 | 5555 | 5555 | 5555 | 5555 | 5555 | 5555
22321 | 22321 | 22321 | 22321 | 22321 | 22321 | 22321 | 22321 | 22321 | 22321 | 22321 | 22321 | 22321 | 22321 | 22321 | 22321 | 22321
444 | 11111 | 444 | 1111 | 444 | 1118 | 444 | 1112 | 444 | 444 | 444 | 444 | 444 | 444 | 444 | 1110 | 444
112 | 11111 | 112 | 1112 | 112 | 1117 | 112 | 112 | 1113 | 112 | 112 | 112 | 112 | 112 | 1111 | 112 | 112
2112 | 11111 | 2112 | 1113 | 2112 | 1116 | 2112 | 2112 | 2112 | 1114 | 2112 | 2112 | 2112 | 1112 | 2112 | 2112 | 2112
3221 | 11111 | 3221 | 1114 | 3221 | 1115 | 3221 | 3221 | 3221 | 3221 | 1115 | 3221 | 1113 | 3221 | 3221 | 3221 | 3221
2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111
2213 | 2213 | 2213 | 2213 | 2213 | 2213 | 2213 | 2213 | 2213 | 2213 | 2213 | 2213 | 2213 | 2213 | 2213 | 2213 | 2213
3211 | 3211 | 3211 | 3211 | 3211 | 3211 | 3211 | 3211 | 3211 | 3211 | 3211 | 3211 | 3211 | 3211 | 3211 | 3211 | 3211
21211 | 21211 | 21211 | 21211 | 21211 | 21211 | 21211 | 21211 | 21211 | 21211 | 21211 | 21211 | 21211 | 21211 | 21211 | 21211 | 21211
2121 | 2121 | 2121 | 2121 | 2121 | 2121 | 2121 | 2121 | 2121 | 2121 | 2121 | 2121 | 2121 | 2121 | 2121 | 2121 | 2121
111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111
121 | 121 | 121 | 121 | 121 | 121 | 121 | 121 | 121 | 121 | 121 | 121 | 121 | 121 | 121 | 121 | 121
88888 | 88888 | 11111 | 88888 | 1111 | 88888 | 1118 | 88888 | 1115 | 88888 | 88888 | 88888 | 88888 | 88888 | 88888 | 88888 | 9999
111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111
212 | 212 | 11111 | 212 | 1112 | 212 | 1117 | 212 | 212 | 1114 | 212 | 212 | 212 | 212 | 212 | 9999 | 212
2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111 | 2111
878 | 878 | 11111 | 878 | 1113 | 878 | 1116 | 878 | 878 | 878 | 1113 | 878 | 878 | 878 | 9999 | 878 | 878
544 | 544 | 544 | 544 | 544 | 544 | 544 | 544 | 544 | 544 | 544 | 544 | 544 | 544 | 544 | 544 | 544
878 | 878 | 11111 | 878 | 1114 | 878 | 1115 | 878 | 878 | 878 | 878 | 1112 | 878 | 9999 | 878 | 878 | 878
99999 | 99999 | 99999 | 99999 | 99999 | 99999 | 99999 | 99999 | 99999 | 99999 | 99999 | 99999 | 99999 | 99999 | 99999 | 99999 | 99999
6546 | 6546 | 6546 | 6546 | 6546 | 6546 | 6546 | 6546 | 6546 | 6546 | 6546 | 6546 | 6546 | 6546 | 6546 | 6546 | 6546
444 | 444 | 444 | 444 | 444 | 444 | 444 | 444 | 444 | 444 | 444 | 444 | 444 | 444 | 444 | 444 | 444
6554 | 6554 | 6554 | 6554 | 6554 | 6554 | 6554 | 6554 | 6554 | 6554 | 6554 | 6554 | 6554 | 6554 | 6554 | 6554 | 6554
4848 | 4848 | 4848 | 4848 | 4848 | 4848 | 4848 | 4848 | 4848 | 4848 | 4848 | 4848 | 4848 | 4848 | 4848 | 4848 | 4848
6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666
5544 | 5544 | 5544 | 5544 | 5544 | 5544 | 5544 | 5544 | 5544 | 5544 | 5544 | 5544 | 5544 | 5544 | 5544 | 5544 | 5544
7777 | 7777 | 7777 | 7777 | 7777 | 7777 | 7777 | 7777 | 7777 | 7777 | 7777 | 7777 | 7777 | 7777 | 7777 | 7777 | 7777
9898 | 9898 | 9898 | 9898 | 9898 | 9898 | 9898 | 9898 | 9898 | 9898 | 9898 | 9898 | 9898 | 9898 | 9898 | 9898 | 9898
115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115
Vertical search: How to search for all numbers with  3,4,5 or 6 digits example : 3 digits : 123 or 456 or 789 or descending 987 , 543 ,321  and numbers like  111 ,222,333,999,888 4 digits : 1234 or 4567 or 6789 or again descending 5432 , 4321 , 9876 and again number 1111,2222,4444,6666,9999 And again for 5 and 6 I want to highlight 3,4,5 or 6 random rows like row 16 , 19 ,22  and search vertical  for them   Diagonal  search: 3 digits : 123 or 456 or 789 or descending 987 , 543 ,321  and numbers like  111 ,222,333,999,888 4 digits : 1234 or 456 or 6789 or again descending 5432 , 4321 , 9876 and again number 1111,2222,4444,6666,9999 And again for 5 and 6 I want to highlight 3,4,5 or 6 random rows like row 16 , 19 ,22  and search diagonal  for them  Can someone help me with explain how to do this ? I can send  a excel file with an example that is easier to understand  Thank you