Forum Discussion
Excel formula to numerically rank preference order
I am trying to create an excel formula that will numerical rank stages in a cycle based on distance from the present stage. So, for example, there are 4 Stages. We are in Stage 3. I would like the fo...
See the attached sample workbook. I used several defined names; you can inspect them in Formulas > Name Manager.
Many thanks, Hans. Accomplishes exactly what I was looking to accomplish. Also taught me some new functions to use in Excel. Many thanks for your response and effort!