I am using Excel 2003 on Windows Vista.
Mostly, I do little calculation in worksheets. I do everything with VBA
in PERSONAL.XLS.
However, I have a new working formula:
<=INT(--(A2<A1)*VLOOKUP($F2,Stations,38,TRUE)+--(A2<A3)*VLOOKUP($G2,St
ations,38,TRUE))
which is copied through to about 3000 rows.
i.e. it does about 6000 VLOOKUP calls and takes a few minutes.
--(A2<A1) and -(A2<A3) evaluate as 1 or 0.
The VLOOKUP calls are unnecessary if those expressions result in 0.
This applies to about 80% of the VLOOKUP calls.
I would like to avoid that 80%.
One thought is the IF function, but that does not do lazy evaluation.
e.g. =IF(True,Truepart,Falsepart) calculates both Truepart and
Falsepart.
I could use a UDF, but prefer the simplicity of calculations in
worksheets.
I would value light from microsoft.public.excel.worksheet.functions.
--
Walter Briscoe