Thanks for all the responses guys once again i am spoilt for choice.

This is most definatley the best forum ever!


Thanks Daddylonglegs

=(E1=$B2)*(E1<=$C2) works great

but why does this not work;
=($E$1=$B2)*($E$1<=$C2)

Cheers

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=503689