Hi,
How do you assign an occurrence number in a cell?
Lets say Column B (B1:B20).
Restriction: 1 is the only valid data to be entered in Column B.

Usage possibilities:
If the user enters €œ1€� at B3, an occurrence number of €œ1€� appears at C3.
If the user enters €œ1€� at B12, an occurrence number of €œ2€� appears at C12.
If the user enters €œ1€� at B1, an occurrence number of €œ3€� appears at C1.
If the user enters €œ1€� at B20, an occurrence number of €œ4€� appears at C20.
And so on€¦

Objective: Chronological cell usage indicator.
The occurrence number will be used by another sheet.

Im still new to excel so please indicate extra details needed for beginners
like me.

Thank you,

Omega