Drop-down lists in Excel are a great way to speed up data entry, keep your sheet tidy, and avoid typos. No formulas required!
AGGREGATE was built to handle messy data from the start.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results