Hi guys,
I am thinking of an idea for a google sheet to have a column (let's say A1 down) filled with wedding guest names. In column B, I will allocate a table number, between 1-20.
In Cell D (titled 'Table 1), how can I write a formula to retrieve the guest names who have (table) '1' allocated?
Thank you!
Bookmarks