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