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

Last Comment
Martin Liss
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

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

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 Liss

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

Martin Yes !!
Martin Liss

Put this formula in C3 and copy down.

=IF(COUNTIF(\$A\$3:\$A\$68,A3)>1,A3,"")

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

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

duobles can be any combinations for example

2253
2532
2523

the double could be in any position
Martin Liss

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

2822 is an triple because have 222 on in

im not talking about duplicates numbers Martin!!

but you rigth !
Martin Liss

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.

Great Job !! Martin ! Great Expert !!

Thnks !!! Martin !!
Martin Liss

You're welcome.
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

TRUSTED BY