Just to add on a little more .. The formula suggested in C7 is essentially
an array formula which needs to be array-entered via CSE.

If you did the CSE confirmation correctly, you should see Excel wrap curly
braces: { } around the formula in the formula bar (ie in C7's formula bar).
If you don't see it (the curly braces), click inside the formula bar and try
the CSE confirmation again.

The visual check on the curly braces is the *only way* (afaik) to check that
the formula is correctly array-entered. If the formula is NOT array-entered,
of course it won't return correctly.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---