Rank() using multiple ranges

[excel3143546]

There have been a few threads with similar questions but none that actually resolved the problem. The best way to ask the question would be to describe the project & expected results:

Data in cells: b3,d3,f3 of 95, 85, 90, repectively
In cells b2,d2, and f2 i want to use the rank function to rank the 3 data cells.

However, the formula would look like this: =rank(b3,b3,d3,f3,0)... and thus would return an error because the rank function only allows 3 arguments.

Is there any way to group the "b3,d3,f3" part / range as a single "second argument?" For example, =rank(b3,range(b3,d3,f3),0). I realize range() does not exist. It is not possible for me to move the data into b3,c3,d3 ... but any solution involving UDFs is acceptable.
Thank you

 

[KenWright]

B2 = =RANK(B3,B3:F3)
D2 = =RANK(D3,B3:F3)
F2 = =RANK(F3,B3:F3)

If for any reason you can't use the entire range because for example you have other numbers in the cells in between then select each of your 3 cells, define a name for the selection, eg mylist and then use

=RANK(B3,mylist)
=RANK(D3,mylist)
=RANK(F3,mylist)

 

[excel3143546]

Nice, it worked. With the actual file I'm using, i'll have to define the necessary ranges (4) in each sheet (about 8) which will leave me with a rather long list. I suppose this is the only way to manage rank function. Other ideas I had were to create a Range function (as displayed in my first post). However, my understanding of UDFs, the function must have a specific value. In other words, can the result/value of a function be an array/selection of cells?