Thanks Tom

That appears to work nicely. Do I need the two "--" symbols? Are yo
able to explain how this formula works?

Thanks

FO

--
FastOneBa
-----------------------------------------------------------------------
FastOneBaz's Profile: http://www.excelforum.com/member.php...nfo&userid=973
View this thread: http://www.excelforum.com/showthread.php?threadid=26205

Hi
if you have stayed in the original thread it would be
easier to answer this :-)
Normaly the '--' (double minus) coerce boolean values
(TRUE/FALSE) to numbers (1/0)

-----Original Message-----

Thanks Tom

That appears to work nicely. Do I need the two "--"
symbols? Are you
able to explain how this formula works?

Thanks

FOB


--
FastOneBaz
----------------------------------------------------------
--------------
FastOneBaz's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=9737
View this thread:
http://www.excelforum.com/showthread...hreadid=262054

.