Need help please

Occasional Visitor

Hi, i work in a dental practice and needed help making a sequence so when i add a prescription num it automatically adds 9 onto the number and generates the next one. It should do this 10 times and then add 19 once and then start adding 9 again.

2 Replies


You provide preciously little detail.

Let's say you enter the initial prescription number in A2.

Enter the following formula in A3:


Fill down as far as you want.