Where is this formula on? Are they referencing the same relative
positions?

For example, if the Value is in D3, and you drag the formula down to
D4, the new formula will be =IF(C3<C4,1," ")


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=556122