Thought I had... but it worked this time.

Thanks very much

"Max" wrote:

"tmirelle" wrote:
I'm getting a value of #NA for all

That's probably because you didn't "array-enter" the formula (press
CTRL+SHIFT+ENTER), as advised in my response. Go back and click inside the
formula bar for B2, then press CTRL+SHIFT+ENTER (instead of just pressing
ENTER) to confirm the formula. If you did it correctly, you'd see that Excel
wraps curly braces { } around the formula (see in the formula bar), and the
formula will work properly. With it properly entered in B2, copy down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---