• 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.

Flag 4 digit identical values, regardless of their order, from a set 4 digit numbers from 0000 to 9999

Status
Not open for further replies.
J

Jeylon

New Member
Hello, hope all is well with you. I must say I am truly impressed with you work and your website.

I am having some problems here and I really do hope you can help me out, please and thanks.

I used a formula in excel to generate a set of 4 digit numbers from 0000 to 9999. This worked perfectly!

However, I am trying to flag all 4 digit numbers that contain exactly the same digits, regardless of their arrangement. For example 1, from my list there is a number 1234. I need you to keep the 1234 but flag 1243, 1324, 1342, 1423, 1432, 2134, 2143, 3124, 3214, 4123, 4213, 4312, 4321 (and all other combinations of it) . Example 2, from my list there is a number 0035, I need you to keep the 0035 but flag 0053, 0350, 0530,3500, 5300, 3050, 5030, 3005, 5003 (and all other combinations of it)

I really hope you can provide some support here.

Anticipatory thanks.
 
Jeylon
Do Your list start from cell H10?
Is Your list vertical or horizontal?
How do You would like to flag those Your named combinations?

Hint: An Excel-sample file,
... with a sample data and expected results
which You could send here,
would help You (and others) a lot.
 
vletm said:
Jeylon
Do Your list start from cell H10?
Is Your list vertical or horizontal?
How do You would like to flag those Your named combinations?

Hint: An Excel-sample file,
... with a sample data and expected results
which You could send here,
would help You (and others) a lot.
Click to expand...
vletm said:
Jeylon
Do Your list start from cell H10?
Is Your list vertical or horizontal?
How do You would like to flag those Your named combinations?

Hint: An Excel-sample file,
... with a sample data and expected results
which You could send here,
would help You (and others) a lot.
Click to expand...

Ok. Well all the unique 4 digit numbers can be listed vertically and all their flagged combinations can be listed horizontally, thanks.
 

Attachments

  • 4 digit numbers generated.xlsx
    96.9 KB · Views: 8
vletm said:
Jeylon
Do Your list start from cell H10?
Is Your list vertical or horizontal?
How do You would like to flag those Your named combinations?

Hint: An Excel-sample file,
... with a sample data and expected results
which You could send here,
would help You (and others) a lot.
Click to expand...
No, it did not start from H10. All I did was generate all the 4 digit numbers, vertically. Now all I need if for ALL same digit combinations to be pulled out from the list so only unique values would remain. Thank you.
 
AlanSidman said:
Where is the list of the four digit number you wish to search for?
Click to expand...
I sent an excel spreadsheet already. So from the sheet I sent I would like all same 4 digit numbers to be flagged. I really don't know how to do it. Thank you for your help still sir.

Here is the list.
 

Attachments

  • 4 digit numbers generated.xlsx
    96.9 KB · Views: 3
Jeylon
Your file do not have any 4 digit numbers
There are 10000 texts, which looks like numbers.

You skipped:
How do You would like to flag those Your named combinations?
as well as expected results.
 
vletm said:
Jeylon
Your file do not have any 4 digit numbers
There are 10000 texts, which looks like numbers.

You skipped:
How do You would like to flag those Your named combinations?
as well as expected results.
Click to expand...
Remember I said I generated a list (10000) of 4 digit numbers? I just want to flag all numbers that have SAME digits, meaning all duplicates, that's all. I will send over the containing ALL the 4 digit numbers. Please highlight, remove or place the duplicates in another cell, thank you.
 

Attachments

  • 4 digit numbers generated.xlsx
    167.6 KB · Views: 6
Jeylon
Based Your original thread (#1)
eg 0001 is same as 0001 0010 0100 1000
that means ... You could have 'left' those 4-digits like 0000 1111 ... 9999
... press [ Do It ] to move Your 'duplicate's to right side.
There are some hints to use too.

Your the latest (#8) reply seems to have 'a bit' different logic,
I'll skip that version.
 

Attachments

  • 4 digit numbers generated.xlsb
    105.1 KB · Views: 7
vletm said:
Jeylon
Based Your original thread (#1)
eg 0001 is same as 0001 0010 0100 1000
that means ... You could have 'left' those 4-digits like 0000 1111 ... 9999
... press [ Do It ] to move Your 'duplicate's to right side.
There are some hints to use too.

Your the latest (#8) reply seems to have 'a bit' different logic,
I'll skip that version.
Click to expand...
Sorry if I was not clear in explaining. The attachment looks good, but not exactly as I wanted. Let me send an example for the last time. Sorry to give you so much worries.

Attached are two documents: 1 is what I really want, the other is what you already did before for someone but with THREE digits. I want the same but with FOUR digits. That's it.

I cannot make it clearer.

Thank you still for your help.
 

Attachments

  • What I really want..xlsx
    168 KB · Views: 7
  • Example of what you did before..docx
    149.6 KB · Views: 3
Jeylon said:
Sorry if I was not clear in explaining. The attachment looks good, but not exactly as I wanted. Let me send an example for the last time. Sorry to give you so much worries.

Attached are two documents: 1 is what I really want, the other is what you already did before for someone but with THREE digits. I want the same but with FOUR digits. That's it.

I cannot make it clearer.

Thank you still for your help.
Click to expand...
 

Attachments

  • Example of what you did before. CORRECTION.docx
    149.6 KB · Views: 5
Jeylon
About Your 1 is what I really want,
Your writings try to explain I should not see 0010, 0100, ...
... You should give an idea - what do You really want?
... and Your newer layout of that data is different than Your original
You should able to keep something stable ... please.
About You but with THREE digits. I want the same but with FOUR digits. That's it.
I did it with FOUR digits ... as You wrote above ... Isn't it Yours That's it?
You seems to send some Word-files too ... no Words for me.
 
vletm said:
Jeylon
About Your 1 is what I really want,
Your writings try to explain I should not see 0010, 0100, ...
... You should give an idea - what do You really want?
... and Your newer layout of that data is different than Your original
You should able to keep something stable ... please.
About You but with THREE digits. I want the same but with FOUR digits. That's it.
I did it with FOUR digits ... as You wrote above ... Isn't it Yours That's it?
You seems to send some Word-files too ... no Words for me.
Click to expand...
Again, my apologies for not being able to explain it clearly. Thank you for your time.
 
Jeylon
Seems ...
Anyway, I did one more sample which has some options
- test Yourself, if any of those would give that You had in Your mind.
 

Attachments

  • 4 digit numbers generated.xlsb
    113.2 KB · Views: 13
vletm said:
Jeylon
Seems ...
Anyway, I did one more sample which has some options
- test Yourself, if any of those would give that You had in Your mind.
Click to expand...
OMG!!! This is exactly what I wanted! You are a genius. Thank you soooooo much. Wow, I am immensely impressed!!!!!
 
The attached uses dynamic array functions such as FILTER and SORT to order the digits within each string and remove duplicates.
Sadly, it is not possible to use a single array formula without recursive Lambda functions, so I used an Excel Table to hold the initial list.
 

Attachments

  • uniqueDigits.xlsx
    337.1 KB · Views: 9
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 a 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.
 
Last edited:
scotty921 said:
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 a 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.
Click to expand...
Please don't hijack the other person's post.

Open a new post with your new question together with the necessary attachment.

This post closed

Regards
 
Status
Not open for further replies.
Back
Top