Dear all here,
First of all thank you very much for your previous help!! This Forum has been and is still of a great help for me and I am learning a lot thank to you!:kiss:
I am asking now regarding a VBA (Macro code) for Deleting Duplicates
There is an option in Excel ("Remove Duplicates") and it does it in the number of cells selected.
It also removes the duplicate the is in the lower position.
Is there a VBA code, or Macro that
THANK YOU VERY MUCH!
For example, I would like to remove duplicates of columns 2 and 3. Therefore Anna and Dandys lines are duplicates and Solomon and Kisas lines are also duplicates (Dandy and Kisas' lines would be deleted)
First of all thank you very much for your previous help!! This Forum has been and is still of a great help for me and I am learning a lot thank to you!:kiss:
I am asking now regarding a VBA (Macro code) for Deleting Duplicates
There is an option in Excel ("Remove Duplicates") and it does it in the number of cells selected.
It also removes the duplicate the is in the lower position.
Is there a VBA code, or Macro that
- DELETES DUPLICATES
- FROM TWO COLUMNS
- ONLY OF THE SELECTED CELLS
- AND CHOOSING WHICH OF THE TWO I WOULD LIKE TO REMOVE (upper or lower)?
THANK YOU VERY MUCH!
For example, I would like to remove duplicates of columns 2 and 3. Therefore Anna and Dandys lines are duplicates and Solomon and Kisas lines are also duplicates (Dandy and Kisas' lines would be deleted)
column1 | column2 | column3 |
Anna | 001 | 01 |
Martha | 002 | 02 |
Solomon | 006 | 02 |
Dandy | 001 | 01 |
Patricia | 003 | 01 |
Frank | 004 | 03 |
Sarah | 004 | 04 |
Laurent | 005 | 05 |
Kisa | 006 | 02 |