Help to take out  from the data  the doubles triples and quatruples

ADRIANA P
ADRIANA P used Ask the Experts™
on
Have an column of data but need to  take
the doubles triples and quatruples like in the example here

i have data with over 3000 records  need make that
take-out-doubles-and-triples-and-qu.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You can remove the duplicates by selecting column "A", and then in the Data Tools pane select "Remove Duplicates".
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Do you just want to do this once? If so then do what I said above. If not then run the RemoveDupes macro that you'll find in this workbook.
29013254.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Thnks Very Much ! Expert Martin

but what's i need is take in other column the doubles triples and quatruples

not remove the duplicates !!
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i'm not interest in the duplicates !!
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
but what's i need is take in other column the doubles triples and quatruples

not remove the duplicates !!
Please try to explain what you mean.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
well i have column A with data  

take in just the doubles numbers and triples numbers and quatruples numbers

to column c

but the data in column A should stay in column A
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Do you want the result to look the way that  column "C" looks now?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin Yes !!
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Put this formula in C3 and copy down.

=IF(COUNTIF($A$3:$A$68,A3)>1,A3,"")
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Sorry Martin  don get the doubles triples and quatruples  with thats formula!!
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i need numbres like 2144  or 2555 or 5555
in column c

duobles can be any combinations for example

2253
2532
2523
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
the double could be in any position
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Do you mean that 2822 is a "duplicate" because it has 3 twos?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
2822 is an triple because have 222 on in
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
im not talking about duplicates numbers Martin!!
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
but you rigth !
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Run the DupeDigits macro that's in this workbook.
29013254a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great Job !! Martin ! Great Expert !!
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Thnks !!! Martin !!
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You're welcome.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial