I believe the attached is what you want. Under the "advanced" compute using settings for your INDEX() calc, you can set the sort order. See attached image and workbook. Cheers!
Rank ML edit.twbx.zip 234.8 KB
Sorry Matthew if I didn't make myselfe clear.
The municipals have a overall rank within the 4 subcategories (groups of points). I need that rank to be viewed at the Ponts sheet.
For example: Skive has the following ranks on the Rank sheet:
Idrætspolitik og foreningsliv: 12
Thise values has to get shown on the points sheet instead of 1, 1, 1, 1 and nothing :-)
Thanks for helping me.
Yes, I completely missed your point. I'm afraid I'm not the best person to help you arrive at this one, though I'm sure its doable. Hopefully someone else can chime in.
You may want to unmark the thread as "assumed answered", so others will know that you are still looking for a solution here.
Whauu - very nice :-)
Now I only need to get it working with the map - use as filter action.
Thanks Matthew for helping me out.