How to distinct the excel

Help
13

Okay… I am gonna help you do this with just excel shortcuts.

You can use
Excel Application Scope to open excel
Select Range Sheet1 - A1 to move to the header
Send hotkey Ctrl + Shift + L - shortcuts for applying filter (make sure filter was not applied earlier)
Select Range Sheet1 - B1 to move to the Column B header
Send hotkey Alt + Down to open the filter dropdown
Type Into “FM7171[k(enter)]” into the search box
Send hotkey Ctrl + a to select filtered text
Send hotkey Ctrl + c to copy filtered text
Select Range Sheet2 - A1 Move to the new sheet (Use a sheet (or create a sheet) in the same workbook like Sheet2. This is easier than copying the content and pasting it in a new excel workbook)
Send hotkey Ctrl + v to paste copied text
Select Range Sheet2 - D1 move to column after D
Send hotkey Ctrl + Shift + Right to select column headers after column C that you want to delete
Send hotkey Shift + Space to select entire column of values
Send hotkey Ctrl + - to delete all columns selected
Select Range Sheet2 - A1 Move to header
Send hotkey Alt + am to choose remove duplicates
Click to click on OK of the ‘Remove duplicates’ dialog window
There you have all the filtered rows, with duplicates removed! Just like this!

Save Workbook to save all these hardwork!!

Its a bit lengthy. Hope it serves your purpose!

1 Like