Sumproduct and frequency funtion sorting

[nparsons75]

I am using macros to pulldata in from closed workbooks. The data goes into a league table.

When I use the formula =SUMPRODUCT( (FREQUENCY($U$11:$U$25, $U$11:$U$25) > 0) * (U11 >= $U$11:$U$26) ) - To rank the link the results are in the wrong order, they descend rather than ascend.

you can see in the image that the rank is working correctly, i.e. 1,1,1,2,3,3,4 etc etc.

The issue is that the ranking (far left in colours) is the wrong way around. I need the 7's to be at the bottom and the 1 to be at the top.Capture.PNG

[daddylonglegs]

Try reversing the second > like this

=SUMPRODUCT( (FREQUENCY($U$11:$U$25, $U$11:$U$25) > 0) * (U19 <= $U$11:$U$26) )

[nparsons75]

WOW, all day I have been trying to figure that out......

Thank you so much.