Oops, small typo he
.. array-enter the formula by pressing CRL+SHIFT+ENTER:
it should read as:
.. array-enter the formula by pressing CTRL+SHIFT+ENTER:
If you do the array-entering correctly, Excel will wrap curly braces { }
around the formula (look within the formula bar). Use this as a visual check
that the array-entering is correctly done, before you copy down. If you don't
see the curlies, you have to try again. Re-click inside the formula bar,
press CTRL+SHIFT+ENTER.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---