Welcome, glad you got it up over there

As for your comment ...
.. actually use the A1:A1000 method instead of A:A ...
it was implicit in the response that simpler entire cols (A:A) cannot be
used, otherwise I would have used it (entire cols)
--
Max
Singapore
-----
"coconut78" wrote in message
...
Dude, you so totally rock!

One thing for others to note: when typing the formula... actually use the
A1:A1000 method instead of A:A.... for some reason, the A:A method doesn't
work... found this out by not taking the free advice given to me by Max.

Thanks Max!