I have a set of NPV values that I need to be automatically ranked when the
inputs change. I received a solution using the "Small" function, but I also
need to rank the name associated with that NPV.

Is that possible?