Formula - Comparing 2 cells continously

[usmanhussain13]

Hi All,

Im trying to think of a formula which i can use and drag down without having to do it manually everytime.

For example, im comparing Cell Value L2 against L3, in Cells M2, and M3, and then id want to compare L4 and L5 in Cells M4 and M5 and so on. Is there any one of doing this and putting a formula in M2 which i can just drag down?

Thanks,

 

[BlueHornet]

If you set up a Table in your worksheet, then as you add rows to the table the formulas in the row above are duplicated row-by-row. That might be the easiest solution for you.

 

[usmanhussain13]

If you set up a Table in your worksheet, then as you add rows to the table the formulas in the row above are duplicated row-by-row. That might be the easiest solution for you.

Hi, sorry what do you mean by set up a table to do this? how would i do this?

 

[BlueHornet]

Let's assume that you have a data range on a worksheet, and the data range contains some of the various formulas that you want to retain.

Go to the Insert tab on the ribbon and select "Table" to set up that data range as an Excel "Table". As you add rows to it, the formulas will be carried down.