davebarton
New member
- Joined
- Oct 20, 2012
- Messages
- 4
- Reaction score
- 0
- Points
- 0
Hi All,
I have a tricky equation that is driving me mad.....please help!
Not sure if a pivot table would work or not.
The data is a finacial report based on hotel rooms and the average money each group of rooms generates.
I have three columns, one with a date, one with a room number, one with a monitary value.
I need to work out the average room revenue, by month, by group of rooms (1-22, 23-40)
Thanks in advance for any suggestions
Regards,
David
I have a tricky equation that is driving me mad.....please help!
Not sure if a pivot table would work or not.
The data is a finacial report based on hotel rooms and the average money each group of rooms generates.
I have three columns, one with a date, one with a room number, one with a monitary value.
I need to work out the average room revenue, by month, by group of rooms (1-22, 23-40)
Date | rm no | revenue | |
oct-11 | 2 | 45 | |
oct-11 | 4 | 76 | |
nov-11 | 42 | 45 |
oct -11 | nov -11 | dec-11 | |
room 1-21 | ?average | ?average | ?average |
room 22-40 | ?average | ?average | ?average |
Thanks in advance for any suggestions
Regards,
David