I am doing an if statement comparing Column B to column D down 100 rows. This I can do in column E =IF(B2=D2, "yes", "No"). Easy. Then I drag it down the other 99 rows and just the row number updates in each formula. EASY. Now I need to shift down data in column a Lets say I need to move B7 through B10 down 4 rows. Then replace the now missing data in B7 to B10. The issue is the formula changed and tracked the moving of the cells in A. so the formula in E10 now reads =IF(B14=D10, "yes", "No") I need it to stay B10 not move to B14. I do know I can go to EVERY E Row and Add $. I need a simpler way. Because in fact I have over 1000 rows not 100....
So stated another way I need to "Lock" the formula in E so no matter what I B or D the formula only acts on the row originally stated.
Thanks...
So stated another way I need to "Lock" the formula in E so no matter what I B or D the formula only acts on the row originally stated.
Thanks...