We help IT Professionals succeed at work.

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

77 Views
Last Modified: 2017-03-31
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
Comment
Watch Question

Martin LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You can remove the duplicates by selecting column "A", and then in the Data Tools pane select "Remove Duplicates".
Martin LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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 PACCOUNTING ASSISTANT

Author

Commented:
Thnks Very Much ! Expert Martin

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

not remove the duplicates !!
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i'm not interest in the duplicates !!
Martin LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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 PACCOUNTING ASSISTANT

Author

Commented:
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 LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Do you want the result to look the way that  column "C" looks now?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin Yes !!
Martin LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Put this formula in C3 and copy down.

=IF(COUNTIF($A$3:$A$68,A3)>1,A3,"")
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Sorry Martin  don get the doubles triples and quatruples  with thats formula!!
ADRIANA PACCOUNTING ASSISTANT

Author

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

duobles can be any combinations for example

2253
2532
2523
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
the double could be in any position
Martin LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Do you mean that 2822 is a "duplicate" because it has 3 twos?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
2822 is an triple because have 222 on in
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
im not talking about duplicates numbers Martin!!
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
but you rigth !
Protect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great Job !! Martin ! Great Expert !!
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Thnks !!! Martin !!
Martin LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You're welcome.