LDT_how to use sort and remove duplicate data

Apply to Excel 2007.

Sort excel data:

1. Click "Data"


2. Click "Sort". then add level by your sequence.


Remove Duplicates:

1. same as above, click "Date" first, then click "Remove Duplicates".


2. Select the column that you want to figure out.