Hi All,
I have here a data set.
In the month of January we processed a total of 283 customers. Would like to ask how to get the average request we get in one day and in one week.
Also, how to get the average from january to december.
Thank you. Appreciate if you can response.
Use Pivot Table.
Try the below formula for per day. A1 is the number of customers per month and 31 is the number of days in the month.
Try the below formula for per week.
Please Login or Register to view this content.
Is this what your asking for?Please Login or Register to view this content.
hI zbor, I HAVE TRIED PIVOT TABLE IT SHOWS AN ERROR #DIV/0
HI JECKFORD, TRIED USING THE FORMULA AND IT WORK. THANK YOU
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks