How to find or highlight all possible combination of a 4 digit number.

Hi

 

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

Leave a Reply

Your email address will not be published. Required fields are marked *