May as well use my own forum for a bit of advice.
I always use VBasic for checking systems, but with little racing today I thought I'd have a go at Excel.
I've imported 2 years of results.
Column A - The horses odds. IE. 1.25, 2.0, 0.8...
Column B - Where the horse was placed. IE 1 (1st), 2 ,3 ...
I want the average odds of those placed '1' only, ignoring the losers. How would I do this in nice baby steps :) I have an idea, but don't want to waste time piddling about with it.