Identifying the 2nd Favourite

[gordon]

Hi Folks,

I notice that BA can identify the first, second and third favourites with icons.

Is there a simple formula to have Excel identify the second favourite.

The reason for my request is to be able to automatically choose a 'clear' favourite within 30 seconds of the published start time.

Any help would be appreciated

Gordon

[gordon]

Or would it be possible to have BA identify the the first, second and third favourites in a column in Excel with titles such as FAV, 2ND, 3RD, for example?

Thanks again,

Gordon

[phrenetic]

Check out the RANK command in Excel.

You can use it to define 2nd, 3rd, ... nth favourite as necessary.

Alistair

[laffo16]

i think phrenetic has hit it on the nail here, alternatively if your storing the data ("name", "odds") in an array or sql, their maybe a function in your language to sort the array "odds" column by asc or desc order.

[Ian]

This is a formula I've used ...

=IF(A5<>"",RANK(F5,$F$5:$F$34,1),"") in Z5 and copied down 30 rows

[gordon]

Many thanks.

Gordon