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