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
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
Last Comment
Martin Liss
You can remove the duplicates by selecting column "A", and then in the Data Tools pane select "Remove Duplicates".
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
29013254.xlsm
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 !!
but what's i need is take in other column the doubles triples and quatruples
not remove the duplicates !!
ASKER
i'm not interest in the duplicates !!
but what's i need is take in other column the doubles triples and quatruplesPlease try to explain what you mean.
not remove the duplicates !!
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
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
Do you want the result to look the way that column "C" looks now?
ASKER
Martin Yes !!
Put this formula in C3 and copy down.
=IF(COUNTIF($A$3:$A$68,A3)
=IF(COUNTIF($A$3:$A$68,A3)
ASKER
Sorry Martin don get the doubles triples and quatruples with thats formula!!
ASKER
i need numbres like 2144 or 2555 or 5555
in column c
duobles can be any combinations for example
2253
2532
2523
in column c
duobles can be any combinations for example
2253
2532
2523
ASKER
the double could be in any position
Do you mean that 2822 is a "duplicate" because it has 3 twos?
ASKER
2822 is an triple because have 222 on in
ASKER
im not talking about duplicates numbers Martin!!
ASKER
but you rigth !
ASKER CERTIFIED SOLUTION
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.
ASKER
Great Job !! Martin ! Great Expert !!
ASKER
Thnks !!! Martin !!
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
