I have an excel sheet with 15 columns and n number of rows. The data’s are 4 digit numbers for example 1234, 7654, 2345 etc.
I need to find or highlight all the blocks having the combination of a particular number. Say if I enter 4557 it should display or highlight all the blocks having 4557, 4575, 4755, 5457, 5475, 5745, 5754 etc…
Appreciate if you can help.
By: Mejo Joseph