Forum Discussion
Pulling "Open" slots from a table into a separate tab
Hi, I'm looking to translate the following table to a separate tab/list showing only Open Times
So a sample output of this new tab/list would be:
Time Slot | Seat | Status
1:00PM - 3:30PM | A | Open
Any ideas? Thanks in advance for the help!!
8 Replies
For some reason my reply isn't showing up. But thank you for all your help!
I actually do have fixed times:
Normal Reservations (Labeled "FT") are 60/90/120/150 minutes long with 15-minutes set-up and 15-minutes bussing
Event Reservations (Labeled "AO") are 120/150/180 minutes long with 30-minutes set-up and 15-minutes bussing.
Any guidance you would have on creating a list like the one mentioned above would be greatly appreciated!
Look into the FILTER function as described in this YouTube video. https://www.youtube.com/watch?v=9I9DtFOVPIg
If you need more help, could I ask you to post a copy of that actual spreadsheet, rather than just an image,
It's also possible that Power Query could work, if you're not on a Mac.
Thanks for the response! Attached spreadsheet found in tab "Table". I'm fiddling with the "Filter" function as well but am not having much success.
In the "Output" tab ideally, the "Seat" and "Time Slots" column should be dynamic showing "Open" slots as the table updates based off of reservations coming into the "Input" tab.
I've linked the "Input Data" tab already to the "Table" in my own spreadsheet so the table changes based off of what is in the "Input" data but only pasted the values over instead of the entire formula in the attached just for demonstrative purposes.
Thanks again for the help and please let me know if any clarity I can provide.
I'm not sure how you want the results displayed, but here are two ways that might be helpful. The second way uses FILTER (as a demonstration of how it might work). I think the other is actually more helpful, and it just uses the tried and true VLOOKUP function.
They will change (or should, at any rate) on a dynamic basis when you update the input, since you say that affects the Table tab. I haven't verified that.
