Avatar of ADRIANA P
ADRIANA PFlag 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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

You can remove the duplicates by selecting column "A", and then in the Data Tools pane select "Remove Duplicates".
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

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 !!
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

i'm not interest in the duplicates !!
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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.
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Do you want the result to look the way that  column "C" looks now?
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

Martin Yes !!
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Put this formula in C3 and copy down.

=IF(COUNTIF($A$3:$A$68,A3)>1,A3,"")
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

Sorry Martin  don get the doubles triples and quatruples  with thats formula!!
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

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

duobles can be any combinations for example

2253
2532
2523
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

the double could be in any position
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Do you mean that 2822 is a "duplicate" because it has 3 twos?
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

2822 is an triple because have 222 on in
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

im not talking about duplicates numbers Martin!!
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

but you rigth !
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Blurred text
THIS SOLUTION IS 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
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

Great Job !! Martin ! Great Expert !!
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

Thnks !!! Martin !!
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

You're welcome.
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo