Forum Discussion
Pulling "Open" slots from a table into a separate tab
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.
Thank you, this is so helpful! I do wonder if it's possible to translate the output into list form like this? Not sure if you know a way to do that.
I'm sure it's possible, but nothing pops to mind immediately.
If you're populating the "Table" data already, based on changes to "InputData," I should think you'd be able to puzzle that through as well. I just don't have the time at the moment, but it'll be percolating in the back of my mind for the rest of the day.
It would help to know if there's a minimum and maximum to the magnitude of reservations you accept. The two examples are quite different, I note. Your basic table of times has a granularity (if one can think of it that way) of 15 minutes, quarter hours. Table reservations would routinely run at least 60-90-120. If one could make some specific assumption about that sort of thing, it would get easier.....That said, assuming you're looking for blocks of time that are open, I would think that this display you already have would be very functional.