OK, here’s the issue.
I need to use a ranking formula in Excel that will do 1 Rank for 3 seperate fields. I’m not an Excel expert, so the formula I’m using works on individual fields, but when I use it for all fields I have 2 phantom ranks.
Here’s the basics
Right now it looks like this
A B
22.00% 8
41.00% 2
52.00% 1
37.00% 5
12.00% 9
18.00% 10
29.00% 6
31.00% 7
10.00% 11
As you can see it skips 2 fields.
Now what you don’t seein the spaces between the 2 groups there is 1 blank line, and 1 total for that grouping.
Now this is the short version because the rankings covers 32 percentages.
Here’s the exact formula I’m using:
=RANK(G4,G4:G13:G16:G26:G29:G39,0)
What am I doing wrong?
What do I need to change?
What formula will work for what I need it to do and get rid of those 2 phantom ranks for me?
Thanks,
Jeff