cancel
Showing results for 
Search instead for 
Did you mean: 

Reply to message

View discussion in a popup

Replying to:
Level 3

Reply to message

Hi @gaugemf ,

 

If you copy the formula J8

IF(I8=I7,J7,G8)

to J7

IF(I8=I7,J7,G8)

 

and then preface J7 with an '=' -- you'll certainly get a circular reference (as it did when I checked).

 

You want to enter the formula in J8 exactly as:

 

=IF(I8=I7,J7,G8)

 

with the leading '=', then copy the contents of J8  down the length of the column.  you should end with something like this (but the length of the column)

 

snip.PNG

 

Essentially, the logic is to compare the current row of COL I with the previous row of column I (that is "Is this (CURRENT) row's Payment the same as the previous (I-1)?") if so Use the SAME DATE (J-1), otherwise (I'm on a new payment) get the new date (G(same row)))

 

Apologies for the confusion, but hope that helps.

 

 

 

 

 

 

 

Need to get in touch?

Contact us