Team ranking with criteria

Today I´ll show you how to rank teams using excel formulas. The following example ranks soccer teams in the Premier […]

How to rank uniquely with criteria in excel

Question: How do I rank column B "within" the same category in column A? See picture below. I want the […]

How to rank text uniquely in excel

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

How to create an array of uniquely ranked duplicate values in excel

Question: How do I rank duplicate values uniquely also I need them in an array? Answer: Array formula in D2: […]

Excel: How to rank by two columns

Problem: How to rank by two columns? Column A are the "group" numbers and column B are the dates. See […]