|
Simple solution: Vlookup
Cells:
a1) 1/22/2007
b1) 6.633
c1) Jan 22, 2007
d1) 51.11
Step1)In a new column (column e) lookup using the following formula:
=VLOOKUP(A1,C: D,2,false)
run this formula for all your 1200 rows
Step 2) Select all cells and sort by column e
/Done. takes 30 seconds
|