Custom Spreadsheet Solutions
Productivity – powered by Excel

Sorted! Complex sorting with SORTBY

SORTBY is a formula you can use to sort data by multiple columns at once or return one column of data sorted by another column. We can return the Company “Names” in order of market share without having to return the market share column. Anatomy of SORTBY(Array to sort: Just the company names for us, […]