Mar 23 2022 04:03 AM
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.
Mar 23 2022 04:48 AM
You provide preciously little detail.
Let's say you enter the initial prescription number in A2.
Enter the following formula in A3:
=A2+IF(MOD(ROW(),11)=2,19,9)
Fill down as far as you want.