Another ranking question
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? |
Can you use a vlookup (or hlookup) to return the name based on the NPV? You
may have a problem if you have ties, but with NPVs that may not be likely. "Liz23" wrote: 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? |
Since retieving the associates of the ranked objects are involved, a
formula system like in: http://tinyurl.com/6k5a4 would be more appropriate. Liz23 wrote: 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? |
All times are GMT +1. The time now is 04:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com