The Excel tier function is an rank function in excel incredibly practical tool for identifying the relative standing of a value within a set of data. In essence, it assigns a position based on how it compares to other values in a list. You can leverage it to see where a particular score sits in a grading system, assess performance against peers, or