|
I was hoping if someone could help me with this one. I've got a small list of 5 hotels, and a spreadsheet of when 300 different people were staying in the hotels. Each person has the date they entered the hotel, the date they left, as well as the hotel name. What I'd like to do is see how many people were in a specific hotel on a specific day, so I can get an idea of what level of occupancy we had on each day for each hotel. I've tried several things, but I can't find a quick way to do it, has anyone got any suggestions?
|
# ¿ Nov 27, 2009 16:59 |
|
|
# ¿ May 6, 2024 20:38 |
|
Worksheet 1 11 columns, but the important info is: Date Occupied (A) Month Occupied (C) Name (E) Hotel Address (G) Date Vacated (I) Month Vacated (J) One row per person. I'd like to have a worksheet with one column for each hotel (5 in total), and a row for each day for the last 6 months, approx 183 rows in total. Each row would contain the number of people in each hotel on that specific day.
|
# ¿ Nov 27, 2009 17:50 |
|
Thank works perfectly, thanks for your help.
|
# ¿ Nov 27, 2009 22:47 |