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.
