Excel has three functions that can rank values. Unfortunately none of them provide a way to create a sequential list of ranking numbers when there are duplicates. Luckily we can adapt the RANK function to handle duplicates and create a sequential list of ranking numbers. In the image below I have used Excel’s three ranking … Continue reading Excel Ranking with Sequential Numbers