Hi everyone,
I looking for some help again.
My table in excel has a number of entries to make up a scoring matrix. Let's say it has 100 rows (but growing), with a total score value from 0 (no data entered) to 24 (current highest possible score).
I want to effectively take the number of rows, and then split to 4 'sections' - let's say 25% each for simplicity. The highest quartile would be Priority 1, down to the lowest quartile being 'priority 4'
So I want to be able to work out what quartile each total score fits into from the overall number of rows with values (not the ones not yet scored - so have a "0" value) which may be more or less than 100 rows.
Then based on the quartile each one falls into, display "priority 1 though to 4"
I'll try an mock up a sanitised dataset I can share here.
I've managed to write the formula to work out the quartile, and I can get it to display the "priority x" result I want but not for all 4 and not a different message if it's displaying "0". So I think I'm on the right track, but it's a bit outside my skill level, so hoping to find some help here
Many thanks, everyone
Nicky
I looking for some help again.
My table in excel has a number of entries to make up a scoring matrix. Let's say it has 100 rows (but growing), with a total score value from 0 (no data entered) to 24 (current highest possible score).
I want to effectively take the number of rows, and then split to 4 'sections' - let's say 25% each for simplicity. The highest quartile would be Priority 1, down to the lowest quartile being 'priority 4'
So I want to be able to work out what quartile each total score fits into from the overall number of rows with values (not the ones not yet scored - so have a "0" value) which may be more or less than 100 rows.
Then based on the quartile each one falls into, display "priority 1 though to 4"
I'll try an mock up a sanitised dataset I can share here.
I've managed to write the formula to work out the quartile, and I can get it to display the "priority x" result I want but not for all 4 and not a different message if it's displaying "0". So I think I'm on the right track, but it's a bit outside my skill level, so hoping to find some help here
Many thanks, everyone
Nicky