AGGREGATE was built to handle messy data from the start.
Your formulas will thank you.
Results that may be inaccessible to you are currently showing.
Hide inaccessible resultsResults that may be inaccessible to you are currently showing.
Hide inaccessible results