Excel placing bets when in favourite order

[davebeddo]

Hello folks, I have recently began to experiment with connecting Excel to BA.
Using a template posted previously by 6thsense (thank you) which sorts runners into favourite order, I have on a second sheet calculated stakes which I would like to place.

My problem is how am I able to transfer this to the Betfair tab and place the bet.

For example the runner in trap three maybe the favourite and would therefore the sheets would be out of sync. I would not be able to use a simple IF to copy the stake from one sheet to another.

Would it be possible to arrange the Betfair sheet into fav order? I have tried this with no success.
Or
Is it possible to use a VLOOKUP to copy the stake from sheet in fav order to Betfair sheet and place bet?

I have genuinely searched the forum and and cannot spot a solution.

Hope I have explained it clearly and that someone can point me in the right direction.

Thanks
Beddo

[PeterLe]

Beddo
If I have understood you correctly..
What you can do is to compare the values in G9, G11, G13 etc...and use the excel command "RANK"
You could then edit you bet command to only place a bet if the RANK is 1
Equally you could for example place a lay bet on the second fav etc etc..
regards
Peter

[davebeddo]

Thanks for the reply Peter that sounds spot on for what I need.