MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula won't increment rows on autofill


Posted by Rod on August 03, 2001 10:56 AM

I am trying to autofill this equation and make the indirect part increment with the rows. It just stays the same when autofilled down:

=IF(COUNTIF(comp!A:A,INDIRECT("$F2"))>0,"old","new")

suggestions?
Rod


Posted by Connie on August 03, 2001 11:10 AM

maybe change your absolute reference with F2 to relative?

Posted by Rod on August 03, 2001 11:15 AM

Re: It is relative to the row...i.e. $f2...keep f, change 2

Posted by Mark W. on August 03, 2001 11:22 AM

Re: It is relative to the row...i.e. $f2...keep f, change 2

$F2" is text so it won't be affected by Fill
or Copy. Use...

=IF(COUNTIF(comp!A:A,$F2)>0,"old","new")