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
Protect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
You can remove the duplicates by selecting column "A", and then in the Data Tools pane select "Remove Duplicates".
Protect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
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
ACCOUNTING ASSISTANT
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 !!
Protect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
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 !!
ACCOUNTING ASSISTANT
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
Protect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Do you want the result to look the way that column "C" looks now?
Protect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Put this formula in C3 and copy down.
=IF(COUNTIF($A$3:$A$68,A3)
=IF(COUNTIF($A$3:$A$68,A3)
ACCOUNTING ASSISTANT
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
Protect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Do you mean that 2822 is a "duplicate" because it has 3 twos?