Okay… I am gonna help you do this with just excel shortcuts.
You can use Excel Application Scope to open excel Select RangeSheet1 - A1 to move to the header Send hotkeyCtrl + Shift + L - shortcuts for applying filter (make sure filter was not applied earlier) Select RangeSheet1 - B1 to move to the Column B header Send hotkeyAlt + Down to open the filter dropdown Type Into“FM7171[k(enter)]” into the search box Send hotkeyCtrl + a to select filtered text Send hotkeyCtrl + c to copy filtered text Select RangeSheet2 - 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 hotkeyCtrl + v to paste copied text Select RangeSheet2 - D1 move to column after D Send hotkeyCtrl + Shift + Right to select column headers after column C that you want to delete Send hotkeyShift + Space to select entire column of values Send hotkeyCtrl + - to delete all columns selected Select RangeSheet2 - A1 Move to header Send hotkeyAlt + 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!