Sort of so close NoRisk , but if I insert a Number into Cell G1 , then the duplicate Rows shouldn't change.
And the Reason they shouldn't change is because Cell F1 is a Blank Cell.
Whenever Cell F contains nothing , then that Row of Numbers needs to stay as it is.(Well it doesn't really , but thats another story which may be revealed once this Formula gets sorted out)


EDIT:
Also - If I insert a number into Cell G4 , then the number in K4 becomes a null and it should stay the same as it was.