Roy,

Two things.

One, the syntax of your COUNTIF formula seems to be wrong. It
apparently should be COUNTIF(range,criteria). I get an error message
when I try your formula.

Two, I'm having a hard time divining what you mean by "remaining
formula." Can you explain that.

Sorry I couldn't help as is.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=487414