Sort by multiple columns

This article demonstrates how to sort a data set by multipe columns using the SORTBY function, Ecel Table and Excel […]

How to rank uniquely based on a condition

The following formula ranks text values in column C uniquely based on the category in column B. Formula in D3: […]

How to rank text uniquely without duplicates

Question: How do I rank text cell values uniquely? If text values were sorted alphabetically from A to Z, the […]