Question, lets say I have every number from 0000 - 9999. I want to eliminate the repeats such as 0001 is the same as 0010 or 0100 or 1000. Do I have to eliminate those manually or is there a way to have it done automatically ? thanks for the help. I'm trying to learn Excel and you all get pretty deep into it, tough for me to follow. thanks again.
I know those are all different numbers but as far as the number itself it would be considered the same for what I'm doing.
2374 Is the same as 3247, 7423, 3724 etc.. for those combinations I just want the 2347 (smallest to largest) and eliminate the rest from the list. hope I explained it okay.
I know those are all different numbers but as far as the number itself it would be considered the same for what I'm doing.
2374 Is the same as 3247, 7423, 3724 etc.. for those combinations I just want the 2347 (smallest to largest) and eliminate the rest from the list. hope I explained it okay.