Excel Trick You Didn’t Know For Ranking Values!

Excel doesn't have DENSE RANK. But sometimes that is exactly what we need. In this video, learn how to use UNIQUE() with LARGE or SORT to create dense rank in Excel, just like how it is in SQL.

Sample file: https://chandoo.org/wp/wp-content/upl...

More Excel formulas:    • Advanced Excel Formula Examples  

#excel #sql #rank