Compare value to individual cells

Hi,

I'm currently trying to rank my data with the rank function according to the picture. (sorry it's the german version but same logic)
rank.PNG
However, in this case I don't have a specific area I want to compare my value with (like Q3:Q17).
Instead, I'm chosing individual cells shown here with "&" (Q3&Q17).
Unfortunately, Using "&" doesn't work for Excel.
How can I achieve that anyways?

Thanks for your help

'RANK' formula: RANK(some_number, range_of_the_array, id), where:
a) some_number - The number whose rank you want to find
b) range_of_the_array - An array of, or a reference to, a list of numbers
c) id - A number specifying how to rank number

If range_of_the_array is not an array (e.g. "A1:A10"), then you must specify/provide a list of numbers, e.g.:

= RANK(15,(10,12,13,15,18,19,20),1)
or
= RANK(A2,(B$2,B$3,B$4,B$5,B$6,B$7,B$8),1)

not "&" as you noticed.

Thank you so much!