Click here to see a demonstration video.
Text Entry
Retain the value in C2 using the value in A2 to identify the row. Initialize new rows with blank text.
=OCRetain(C2,"",A2)
Numeric Entry
Retain the value in C2 using the combination of values in A2 and B2 to identify the row. Initialize new rows to display zero.
=OCRetain(C2,"=0",A2,B2)