Question

excel

  • 5 January 2023
  • 3 replies
  • 54 views

Badge +2

in excel how to remove duplicate values from an column?


3 replies

Userlevel 4
Badge +9

@mohank06  VB marcro :: https://www.wallstreetmojo.com/vba-remove-duplicates/#:~:text=VBA%20Remove%20duplicates%20%E2%80%93%20Example%20%231,-Consider%20the%20below&text=Step%201%3A%20Start%20the%20sub,using%20the%20VBA%20Range%20object.&text=Step%203%3A%20After%20mentioning%20the,access%20VBA%20%E2%80%9CRemoveDuplicates%E2%80%9D%20method.&text=Step%204%3A%20First%20argument%20in,to%20remove%20the%20duplicate%20values.
 

within Excel : https://www.laptopmag.com/articles/remove-duplicate-entries-excel

 

Badge +2

i asked from a360 how can we remove it?

 

Userlevel 4
Badge +8

Hi @mohank06 ,

I did’t notice an option in the a360 actions to remove duplicates. You can use a taskbot from BotStore and check if it can be useful for you.

https://botstore.automationanywhere.com/bot/a2019-multiple-excel-utilities-and-operations

Or you can use the approach using simulate keystroke to access to option Remove Duplicates  y then using Recorder

Simulate kystrokes  Alt+A+M 

 

Try using Recorder to confirm the selection and perform the remove.

 

HTH

Regards

Reply