Excel: Custom formulas for customer/order data
$25-50 USD
Betales ved levering
I have an excel-sheet with the following columns; "Date for order", "Name of customer" and "Order amount". The excel-sheet contains all the orders that were made in my shop for the past 2 years. I need to get as much data as possible about the returning and non-returning customers and the orders. See an example of the excel-sheet attached.
Definition:
Returning customer: Customers that made more than 1 order.
Non-returning customer: Customers that made only 1 order.
I need formulas for the following questions:
1. Qty. of unique returning customers?
2. Qty of unique non-returning customers?
3. Avg. order amount for returning customers?
4. Avg. order amount for non-returning customers?
5. Avg. time (days) between orders for returning customers?
6. How many % of returning customers make a purchase within 90/180/360 days?
7. How many % of the purchases are returning purchases?
And also I need you to build a table that presents the top-50 best returning customers. Each row should contain the following data per customer:
Column 1: Name of (returning) customer
Column 2: Qty. of orders
Column 3: Tot. order amount
Column 4: Average time (days) between orders
I should be able to sort column 2,3 and 4 according to the amount.
Note! I should be able to add new data
Prosjekt-ID: #5480559
Om prosjektet
Tildelt til:
Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Mer
24 frilansere byr i gjennomsnitt $47 for denne jobben
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementaiton.
Hi, My name is Jon and I will be happy to help you with this project. I can do it rather quickly if we can start on it today
Hi Komorin. I can do the job in a day. I have done much more complex calculations in Excel before and I can easily handle these. Kindly discuss. Regards. Usman.
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
Hi, I am experienced Excel / VBA / macro programmer. This is very easy ask for me. I'll come up with demo for you. Thanks and Regards, manishadk
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 7 years in IT projects with 5 years working around Microsoft database ( Mer
Hi There, I am an expert in excel macro/VBA and would be glad to work on your project. I can send you a sample if you wish. Please let me know. Regards, Bharat
It can be made in MS Access database. More flexible data entry and reporting. For more details please reply. Thanks
Dear Sir/Madam, You may consider it's done. I am an Excel expert with proven experience in freelancer.com. Please, refer to my feedback.
I am a professional software engineer. I am ready to take this work. my skill set and experience are best suitable for your requirement. Please assign this task to me I will make sure your work will be completed 100% Mer
Hi There, Thanks for posting the project details. Its looks feasible and interesting to me and would like to get this done. Next steps: Lets discuss more on the requirements/outputs and data format/analysis r Mer
* OM SAI RAM * Respected Sir/Mam, I have read the project completely and I have understood my responsibilities (If awarded) clearly. To tell more about myself, I am dedicated and sincere in working on the pro Mer
Hello, I am a Microsoft certified trainer (MCP Id: 7531519) for MS Excel and Office automation. I have been teaching Excel and delivering automation solutions on Excel to corporate employee for the past 9 years. I h Mer
Respecred Sir, I am ready, i sure you will be like my job, awaiting for your positive response, thanks.
Hello, it is so easy, please consider my bid, and i am ready to send you the solution. Regards.
Hi! I am working at the bank in Ukraine and have already gained a 3-year experience in vba and excel.