View Single Post
 
Old 02-22-2020, 06:07 AM
mandersen04 mandersen04 is offline Windows 10 Office 2016
Novice
 
Join Date: Sep 2018
Posts: 12
mandersen04 is on a distinguished road
Default

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
File Type: xlsm Copy of CRW Addresses for Matt.xlsm (22.8 KB, 9 views)
Reply With Quote