Since Microsoft forgot to do a Rankif function I need to do this manually.
I need to rank values according to two criteria. It's basically like the normal Rank function but in the reference part in needs to rank within specified ranges. I included a simplified example, but hopefully it should illustrate the point.
I was experimenting with sumproduct but it's a lot of data so I coudn't get it right...
Appreciate the help!
Bookmarks