by London_Calling » Mon Mar 03, 2008 11:23 pm
Ev'nin all,
I’m really struggling for the right word here,please bear with me.
Say I’m laying two runners at different odds but for the same potential loss. In, say Column z, I’d like those two runners to have in their relevant row an A or B depending on which of them was laid at the lowest odds (an A in this cell) and which was laid at the higher odds (a B in this cell).
I can do that with formulas (using column V or W via Bet Assistant), the problem comes when other bets are introduced and the numbers change in column V or W - A is no longer the A and B is no longer the B and I need the initial A and B to stay as A and B even after changes occur in columns V or W.
I guess this will probably be a VBA solution, any ideas?
Cheers