Excel or any spreadsheet next order date or any related column

In excel or any spreadsheet if you want to have:
• customer next order date
• customer next purchase or order number
• to calculate customer purchase period
• customer order frequency
• …

You have to have the customer number and order date. Also having invoice numbers would be helpful because sometimes orders will break into different invoice numbers. So if we have: customer number in C and invoice numbers in B and order date in D
Just do this:
order by date, order by customer number
then your next order date would be:
=IF ( AND (C2=C1,B2<>B1),D2,””)

پاسخی بگذارید

نشانی ایمیل شما منتشر نخواهد شد. بخش‌های موردنیاز علامت‌گذاری شده‌اند *

Time limit is exhausted. Please reload CAPTCHA.