![Old](images/statusicon/post_old.gif)
6th November 2014, 12:52 PM
|
Banned
|
|
Join Date: Feb 2013
Posts: 755
|
|
Quote:
Originally Posted by Toil
Hi Rinconpaul,
I know this gives you a percentage change =(A1/B1)-1
But probably not what your after.
Shaun or someone would definitely be able to help you I'm sure.
|
Thanks Toil. Yes it's easy enough to work out on a case by case basis, the difficulty is the number of rows for each runner is forever changing, so the formula needs to be intuitive and know when it's a different runner and be able to count back to the beginning to find out what the first odds value was. It needs to be automatic, as tens of thousands of entries to assess.
|