Hi Kanti
Many thanks. A lot of thought has gone into this.
I will do as suggested and give you some feedback later today.
Once again that for your time and talent.
Hi Kanti
I have tried to modify your formula to include other descriptors as follows:-
In most cases the "1" would default to the second week.
However, in the formula below I have not been able to include "Annually" -say in week 2 of July...
Hi Kanti
Many thanks for the formula. It works very well for the weekly and monthly frequency as per my posting above.
As usual the request from the team is to add more frequency descripter types - namely "Bi Monthly" (ie six times a year), "Quarterly" ((ie 4 times a year), "4 Monthly" and...
Hi
I would like to know if it is possible to auto populate a spreadsheet row (right side) with the number "1" depending on the frequency descriptor on the (left cell).
I have a call cycle spreadsheet whereby:
Column A is the customers_name
Column B is the frequency of calling eg...