Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

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

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
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
Martin Liss

You can remove the duplicates by selecting column "A", and then in the Data Tools pane select "Remove Duplicates".
Martin Liss

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 P

ASKER
Thnks Very Much ! Expert Martin

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

not remove the duplicates !!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ADRIANA P

ASKER
i'm not interest in the duplicates !!
Martin Liss

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 P

ASKER
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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

Do you want the result to look the way that  column "C" looks now?
ADRIANA P

ASKER
Martin Yes !!
Martin Liss

Put this formula in C3 and copy down.

=IF(COUNTIF($A$3:$A$68,A3)>1,A3,"")
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ADRIANA P

ASKER
Sorry Martin  don get the doubles triples and quatruples  with thats formula!!
ADRIANA P

ASKER
i need numbres like 2144  or 2555 or 5555
in column c

duobles can be any combinations for example

2253
2532
2523
ADRIANA P

ASKER
the double could be in any position
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

Do you mean that 2822 is a "duplicate" because it has 3 twos?
ADRIANA P

ASKER
2822 is an triple because have 222 on in
ADRIANA P

ASKER
im not talking about duplicates numbers Martin!!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ADRIANA P

ASKER
but you rigth !
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Great Job !! Martin ! Great Expert !!
ADRIANA P

ASKER
Thnks !!! Martin !!
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

You're welcome.