Excel 365
· 9 min read
Build a Dropdown List That Removes Items Once They're Picked
Standard Data Validation dropdowns have no idea what's already been chosen elsewhere — which is exactly how the same meeting room, laptop or seat ends up double-booked. Here's the classic OFFSET trick, the one-formula 365 FILTER fix, the one hole neither of them closes, and a free workbook.
Read article