Look at the 2-column table below, which describes the Department and Employee ID of 20 employees. However, each Department value appears only once. (This is typical of a downloaded dataset where the first column is a grouping column.) Our task is to copy and paste the…
Use Ctrl + Shift + L to bring up the Filter drop down menu, but first make sure you highlight the headings or fields….see below image 2. Ctrl + Arrow keys to navigate through your data boundary If you want…
There are multiple methods of extracting duplicate records. But when it comes to VLOOKUP then this video will help you. First, lets start with the Filter Function. Filter Function is only available in Office 365. Type, Filter, it will ask…
