RANK - using form control to change ranking criteria

[Tacalabala]

I think the description sum it up really, just can't get my head around how to do this.

Basically, columns E to 0 all contain data that could be ranked, and I'd like the ranking data (column A) to be able to change to whatever range I'd like to look at, ideally using a form control (list box?) as a mean to go from one to another at will.

Help much appreciated

[ChemistB]

So this list would consist of the headers on E to O? If not, what's the list?

Let's say the headers are in row 1, data in E2:O100

Setting up Data Validation in B2 for your list, In A2 copied down

=RANK(INDEX($E$2:$O$100, ROWS($A$1:$A1), MATCH($B$2, $E$1:$O$1,0)),INDEX($E$2:$O$100,,MATCH($B$2, $E$1:$O$1,0)))
See attachment

[Tacalabala]

That is brilliant, exactly what I was after! Yep, there are header, it's for fantasy football so things like points, cost, team value.