I think I've got it

If I put this in column A of the 'EU FuUnds' sheet and drag it down to the bottom cell, this seems to work:

=RANK(INDEX($B2:$Z2,MATCH(selected_date_product,$B$1:$Z$1,0)),INDEX($B$2:$Z$191,1,MATCH(selected_date_product,$B$1:$Z$1)):INDEX($B$2:$Z$191,190,MATCH(selected_date_product,$B$1:$Z$1)))+COUNTIF(INDEX($B$2:$Z$191,1,MATCH(selected_date_product,$B$1:$Z$1)):INDEX($B2:$Z2,MATCH(selected_date_product,$B$1:$Z$1,0)), INDEX($B2:$Z2,MATCH(selected_date_product,$B$1:$Z$1,0)))-1
Does this look right?