I have a column called VISITS, where numbers are from 3,4,6,12.
Now depend on the number I should have these numbers equally distributed in months.
For Example, VISITS=4, if I devide 12 months by 4, answer is 3. Now tis number 3 should be splitted in 12 months, i.e. my 1st visit will be in month of JAN 2nd will be in month APR and so on
Below is table, this is how I am expecting a formula to do this automatically based on my VISITS:
|4||Visit will be after every 3 months||1||2||3||4|
|6||Visit will be after every 2 months||1||2||3||4||5||6|