jeudi 17 septembre 2020

AND IF Excel formula returning incorrect value

I'm trying to write a formula that will count number of edits in my data. Column A will tell how many times the data has been edited using

=IF(AND($D5468=$D5467,$G5468<>$G5467),0)+1

formula. Basically what I wanted is, if value in column D is the same and value in column G is the same, it will count as one. And will continuously count as the date change. My issue is that in the middle of my counting "Highlighted in Yellow" I wanted the 2nd one to remain as 2 since it is just the same with the previous one but it is returning to one. Is there any way I can solve this?

enter image description here

Aucun commentaire:

Enregistrer un commentaire