Oh yes Max....i actually overlooked it.
Thanks...its working.
Thanks Biff.
"Max" wrote in message
...
But perhaps you overlooked Biff's step on array-entering the formula,
Enter this formula as an array using the key combination of
CTRL,SHIFT,ENTER (CSE)
In the formula bar, if confirmed correctly you should see* curly braces
{ }
inserted by Excel at both ends: {<formula} (don't type-in these braces!).
Once confirmed correctly, the array formula can then be copied down as per
normal formulae.
*Visual check this before you proceed to copy the formula down
Note that the CSE has to be re-done each time should the formula be edited
for whatever reason. You'd get wrong results if the formulas are not
correctly array-entered. It's all too easy to forget to do the CSE <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---