Posted to microsoft.public.excel.worksheet.functions
|
|
Unable to get examples to work for lookup etc
Oops, correction to description. Lines:
In C2:
=IF(ROW(A1)COUNT(E:E),"",INDEX($A:$A,MATCH(SMALL( E:E,ROW(A1)),E:E,0)))
In D2:
=IF(ROW(B1)COUNT(F:F),"",INDEX($A:$A,MATCH(SMALL( F:F,ROW(B1)),F:F,0)))
should simply read as:
In C2:
=IF(ROW(A1)COUNT(E:E),"",INDEX($A:$A,MATCH(SMALL( E:E,ROW(A1)),E:E,0)))
Copy C2 to D2
(The formula in D2 is just a sweet copy across of the one placed in C2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
|