• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

0000 - 9999 without the repeats

scotty921

New Member
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.
 
Top