Hello everybody, I attach a file which contains the details for booking 2011, could everyone help me to calculate 2 most common" booking start days" of all bookings about booking number and revenue.
And pivot table, use it to create 2 graphs, revenue breakdown by (1. each apartment) (2. booking start days of a week).
THanks all
Book1.xlsx
Hi,
See attached file with :
- 2 most popular using pivot table
- 2 charts using pivot table and pivot chart
Hope this help ?
Best regards
thank jpr73 for your help, can you use other ways to calculate 2 most common booking start days (e.g =MODE or =COUNTIF). THank you again :D. sorry for my bad english
One way, array entered (Ctrl+Shift+Enter instead of just Enter) in G2:
Formula:
=INDEX(TEXT(DATE(1904,1,ROW($4:$10)),"dddd"),MATCH(LARGE(COUNTIF($C$2:$C$50,TEXT(DATE(1904,1,ROW($4:$10)),"dddd"))+ROW($1:$7)/10,ROW()-ROW($2:$2)+1),COUNTIF($C$2:$C$50,TEXT(DATE(1904,1,ROW($4:$10)),"dddd"))+ROW($1:$7)/10,0))
Copied down to G3.
Cells G2 and G3 used as example. If you want to use this formula starting in a different cell, just make sure that ROW($2:$2) actually points to the row of the first cell that you put the formula in.
Steve D. a.k.a. Stephen Dunn
I can't understand that, can you display in a sheet :D, but thank stunn very much ^^
Here's an example file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks