Video 00058 Filter Out Number (digits in any order)

Imagine a column of numbers. Each number is 3 digits in length.

If we select 127 then we want to also hide 127, 172, 217, 271, 712, and 721 (six unique orders).

In this video I show you two possible solutions. 

Both solutions use several easy steps to create a helper column with TRUE and FALSE values used to filter out rows.

 

How many combinations?

You can use this formula:  =FACT(LEN(127))  to determine that there are 6 possible different orders of 127

FACT = factorial so the length of 3 equals 3! which is 3X2X1 = 6.

 

Watch my YouTube video

 

Subscribe to my YouTube channel and learn more!

See my free templates here!

Leave a Reply

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