So I really appreciate your help last week. I have since added a worksheet to my workbook, wherein I rank the distances for each person in relationship to each other. I have attached the same file with the third sheet added, so you'll see what I mean.

The sheet 1 tab contains the rankings from smallest to largest (i.e. closest to farthest away), and right now I'm using an Index Match formula and a Small formula. However, right now, the Small formula references a specific row in the Distance tab, meaning that if I ever sort the rows in the Distance tab in a different order, the rankings will be incorrect. I know I need to reference the person's name in the formula and leave out the specific row reference, but unfortunately, Index Match formulas are not my strong suit. Any suggestions? Do I need an Array formula? What would it look like?

Thanks!

Attached Files

Copy of CRW Addresses for Matt.xlsm (22.8 KB, 11 views)