Excel
· 7 min read
Excel 365: 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 and the one-formula 365 FILTER fix, plus a free workbook.
Read article