sorry to be a pain

yeah i wanted it to extend to other rows

so in row A4

=(E1=$B4)*(E1<=$C4) works fine but,
=($E$1=$B4)*($E$1<=$C4) does not

with my limted knowledge these two formulas are the same until you drag
them are they not?


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