OCRetain Examples

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)