Hi Excel community,
I am having an issue where my formula is not copying over to the other cells.
example:
I want the formula to say
=IF((C9=AA1),1,0) however im getting =IF((C10=AA3),1,0). I want the formula to always say AA1. when I use the formula + to copy down the formula the rows do not change to the formula I want. does any one know what the issue may be?
Thanks
Bookmarks