James_Latimer
Active Member
- Joined
- Jan 20, 2009
- Messages
- 415
Excel - O365
Hi all,
I'm having a mental block and need some help from the ever amazing Excel gurus.
I have two columns of values, 'number of submissions' and '% won'. I want to rank my data based on % won (descending), then based on that use number of submissions (descending).
So...
Ideally i need the ranks to be unique too (which is adding to my headache) so that i don't get duplicate ranks.
I've looked at this for so long that i'm starting to question whether some of these words i'm reading even exist...
Thanks in advance to anyone who can offer me some assistance.
Hi all,
I'm having a mental block and need some help from the ever amazing Excel gurus.
I have two columns of values, 'number of submissions' and '% won'. I want to rank my data based on % won (descending), then based on that use number of submissions (descending).
So...
Ideally i need the ranks to be unique too (which is adding to my headache) so that i don't get duplicate ranks.
I've looked at this for so long that i'm starting to question whether some of these words i'm reading even exist...
Thanks in advance to anyone who can offer me some assistance.