Non VBA ,
I need a count of the last consecutive
clients ( yellow shades )
Formula on C55 to drag right
Expected answer is 12 on February and 12 on March
Non VBA ,
I need a count of the last consecutive
clients ( yellow shades )
Formula on C55 to drag right
Expected answer is 12 on February and 12 on March
Why isn't Cell D42 included in March? Shouldn't it be 13?
Because we have sold to the client in c41 thus his not new client
Even if I get a formula that will include that not bad , I would simple minus 1
The total customers per month than will be count all minus new clients
Take a look at your spreadsheet. Is it REALLY possible for a new customer (C40 in cell C41) to start with a return?? Please let me know...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I think this formula is tough to achieve , may I should create column
and plug the word new
Last edited by makinmomb; 12-14-2014 at 12:40 PM.
Then will work quick with countif perhaps
Last edited by makinmomb; 12-14-2014 at 12:40 PM.
Re attaching making the logic easier
I already have counted it here..
Sheet2 Count Columns
Check the attached file..
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Vikas this is un beatable usage of FLEXI , too good must say
I am looking for something simpler within the same sheet without FLEXI
I can't get this working the way I wanted... If you are prepared to add another array in for each month ( to read =SUMPRODUCT(--(ABS(E2:E54)>0)*(($B2:$B54=0)*($C$2:$C$54=0)*($D$2:$D$54=0))) for April, etc... , then this will do the job.
Glenn this is good enough to close the thread , thanks
OK. The formula will get rather cumbersome as you add on the extra months... But if it does your job, then that's fine.
Copy Pasting , then edit reference will cut the wire of time
I will do it for once for 12 months and will use save as copies
OK. You do seem to have got what you wanted, after all. Thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks