Compare value to individual cells

'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!