Hi Barry,
Hehehe, never been good at expressing my problems ...
OK, what I wanted to achieve in calculating how many times the Inital PN # rollover ....
eg ... if I enter 7778 in C21
Initial PN # will appear as 1206 in C14 (thanks to you.....)
And ... the No. of Rollovers (where the problem is...) should be 1, instead of 2 ... reason being though 7778 appears twice it should be counted as only once....
Help pls, thanks...