Would like a formula in column D of the attached
file that would identify by customer the largest # of
days of consecutive sales. Thanks for your efforts on this!
Would like a formula in column D of the attached
file that would identify by customer the largest # of
days of consecutive sales. Thanks for your efforts on this!
Last edited by clockspring; 03-31-2014 at 08:52 AM. Reason: Solved
=IF(C7<C8;"";C7)
Try this formula in cel D7 an pull down.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Try in D7, then copy down.
=IF(COUNTIFS(A$7:A$19,A7,C$7:C$19,">="&C7)=1,C7,"")
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
This worked well fro my situation. Many thanks!
Thank you Haseeb - your formula worked great for my situation!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks