Hi
I would like to be able to calculate which customers have not purchased from me in the last 6 month via a formula.6 months no buy.xlsx
I have attached a spread sheet with an example of what I need
Hi
I would like to be able to calculate which customers have not purchased from me in the last 6 month via a formula.6 months no buy.xlsx
I have attached a spread sheet with an example of what I need
Last edited by mintribe; 12-09-2011 at 01:17 PM. Reason: question was answered and solved
=if(count(h3:m3)>0,"yes","no")
Try:
=IF(COUNTA(OFFSET(N3,0,-6,1,6)),"YES","NO")
copied down
This allows you to insert columns before column N and maintain the condition.
Edit:
Sorry previous formula was incorrect.
Last edited by NBVC; 12-09-2011 at 12:37 PM. Reason: misunderstood originally
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Fantastic thanks that worked a treat
SOLVED my problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks