Quote:
Originally Posted by impactX
|
I don't see any formulas, where can I find out what you did?
not really what I want, but it helps identifying what's not needed.
Quote:
Originally Posted by Wetordry
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
|
Quote:
Originally Posted by Gumby
Given =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), I think you have the lookup_value and table_array flipped.
It should be =VLOOKUP(C1, A:B,2,"false").
The way you have it, you won't find the two bolded dates (from column A) in column C.
|
Let me try these and I will report back.