hey

a function i have counts a list of names if the logical test is true,
but if the logical test is false, how would i get it to keep the result
it had from when it was true?

eg. if the month and year is equal to the current month and year,
perform action, if not, keep the result from the true test.

it is column C that has this function in. at the moment, in the false
test, the function looks at the above cell, i know this is wrong.

i have attached an example doc to explain.

thanks

Jamie


+-------------------------------------------------------------------+
|Filename: Book.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4767 |
+-------------------------------------------------------------------+

--
jay d
------------------------------------------------------------------------
jay d's Profile: http://www.excelforum.com/member.php...o&userid=34487
View this thread: http://www.excelforum.com/showthread...hreadid=542487