ExtremeTechPC
New Member
- Joined
- Apr 24, 2018
- Messages
- 2
So since all pick 3 and pick 4 numbers have different combinations possible, I want excel to highlight them based on how many times each combination repeats. I want to do this for 3 and 4 digit sets separately. Ultimately I want to paste all winning numbers in column A
in let's say every March from 2001-2018
and I want excel to find out the # that comes the most in March. Can this be done?
"So for example the number 1000 ""boxed"" it would have to pick out" All 1000, 0100, 0010, and 0001 numbers as a boxed combination.
But some numbers have more sets of combinations would they all be able to exist on the same sheet. Is it possible to have excel highlight the combinations that repeat more than once? Or a different color if they repeat 2,3,4, times...etc?
in let's say every March from 2001-2018
and I want excel to find out the # that comes the most in March. Can this be done?
"So for example the number 1000 ""boxed"" it would have to pick out" All 1000, 0100, 0010, and 0001 numbers as a boxed combination.
But some numbers have more sets of combinations would they all be able to exist on the same sheet. Is it possible to have excel highlight the combinations that repeat more than once? Or a different color if they repeat 2,3,4, times...etc?