To the 3 Great Minds,
Thanks guys, they all worked. You all must have very strong necks to support
those giant brains. Could you modify the formula to only work in the
destination cell if the letter "S" is entered in the source cell? Again
thanks to all 3.
Best Regards,
Malcolm

"Gord Dibben" wrote:

Always tweaking<g

Shorter and more readable.

Thanks Biff


Gord

On Sun, 30 May 2010 12:21:34 -0400, "T. Valko"
wrote:

Another way to write the same formulas already suggested...

=IF(OR('End Bal'!B5={"","No Show"}),"",'End Bal'!B5)

.