Hello everyone,
I have a simple IF function, but I would like to have the value if false auto-fill from the line above, is that possible? I've looked around the forum but I can't find anything.
In context, we receive orders from the night before, if they have the same PO number I would assign them the same order number (alpha numeric - Otherwise I could just put the previous cell +1) as the order above, but if they have different PO numbers it would autofill to the next order number.
So, my IF statement would look something like this (with the auto-fill part of the false value being incorrect - obviously since that's my question):
IF(G3=G2,C2,AUTOFILL(C2))
Thank you!
Bookmarks