Excel: dynamic ranking
Budget: $10 – $30 USD
hi excel cracks
i have a items which each has 2 value cells: first cell is "impact" (values 1-4, 1= low) and 2nd cell is "complexity" (values 1-4, 1 = low).
Now i want to have a dynamic ranking of my items based on the calculation of the both values.
Eg. item "emailing" has a high impact (4) but it's low complex (1)= 5 score points.
If another item would have a low impact (1) but it's high complex (4)= this item would also have 5 score points. but in terms of priority it's not comparable with the first item, as I want to prioritize items which have a high impact plus a low complexity.
Expected output:
dynamic sorting/ranking of the items with the associated ranking number
i have a items which each has 2 value cells: first cell is "impact" (values 1-4, 1= low) and 2nd cell is "complexity" (values 1-4, 1 = low).
Now i want to have a dynamic ranking of my items based on the calculation of the both values.
Eg. item "emailing" has a high impact (4) but it's low complex (1)= 5 score points.
If another item would have a low impact (1) but it's high complex (4)= this item would also have 5 score points. but in terms of priority it's not comparable with the first item, as I want to prioritize items which have a high impact plus a low complexity.
Expected output:
dynamic sorting/ranking of the items with the associated ranking number