Hi
Not sure im in the right place for this question but here it goes
I have a betting spreadsheet database with 37 column headings, what can i do to search the data using only the following columns to return the most profitable scenarios
Column 4 - League
Column 7 - Home Odds
Column 8 - Draw Odds
Column 9 - Away Odds
Column 18 - Home Back return - based on the odds from column 7 either a minus or plus return
Column 19 - Draw Back return - based on the odds from column 8 either a minus or plus return
Column 20 - Away back return - based on the odds from column 9 either a minus or plus return
Column 21 - Home Lay return - based on the odds from column 7 either a minus or plus return
Column 22 - Draw Lay return - based on the odds from column 8 either a minus or plus return
Column 23 - Away Lay return - based on the odds from column 9 either a minus or plus return
Column 29 - Home average
Column 35 - Away Average
Column 36 - Home colour ( dependent on average in column 29 )
Column 37 - Away colour ( dependent on average in column 35 )
Its a long shot i know, there are that many combinations it would take tens of days to do manually is there a quicker way??
thanks
Bookmarks