Excel Data Management: Removing Duplicates, Sorting & VLOOKUP
EC

Excel Courier

Created Sep 13, 2024

Excel Data Management: Removing Duplicates, Sorting & VLOOKUP

17
    e

FUNctions with Fil Sept 12.xlsx

19 Steps
1

Right click on highlight and copy the column.

Right click on highlight and copy the column.
2

Right click on highlight and paste the data in a new column

Right click on highlight and paste the data in a new column
3

Click on Paste…

Click on Paste…
4

Click on Data Tools

Click on Data Tools
5

Click on Remove Duplicates

Click on Remove Duplicates
6

Click on OK

Click on OK
7

Click on highlight

Click on highlight
8

Click on Sort Descending

Click on Sort Descending
9

Type GENERAL SERVICE TYPE as your column label

Type GENERAL SERVICE TYPE as your column label
10

Type GENERAL SERVICE TYPE again as your column header

Type GENERAL SERVICE TYPE again as your column header
11

Type DEDICATED for the two service types that are dedicated and ON DEMAND for the remaining service types.

Type DEDICATED for the two service types that are dedicated and ON DEMAND for the remaining service types.
12

Click on highlight

Click on highlight
13

Use the fill handle to propagate the remaining cells with "ON DEMAND".

Use the fill handle to propagate the remaining cells with "ON DEMAND".
14

click to highlight the cell where you will enter your VLOOKUP function.

click to highlight the cell where you will enter your VLOOKUP function.
15

Type =VLOOKUP(

Type =VLOOKUP(
16

Type =VLOOKUP(C2, or click in the cell you will use as your lookup value.

Type =VLOOKUP(C2, or click in the cell you will use as your lookup value.
17

Click and drag to select your table array. Add a comma. Enter the column number where you want the function to "look". Add a comma, then type "false)" and hit enter.

Click and drag to select your table array. Add a comma. Enter the column number where you want the function to "look". Add a comma, then type "false)" and hit enter.
18

The function returned the value you requested. Now double click on the Fill Handle to pull your formula down the rest of the column.

The function returned the value you requested. Now double click on the Fill Handle to pull your formula down the rest of the column.
19

You did it.

You did it.
Well done!
Create how-to guides like this in a snap. Get Tango now.