6th November 2014, 01:20 PM
|
Member
|
|
Join Date: Nov 2010
Posts: 49
|
|
If you can get MS Query to work (I tried but it doesn't want to play nice) you could do this using SQL - something like:
SELECT MAX(course), MAX(event), (MAX(odds) / MIN(odds)) FROM [table_name]
GROUP BY event_id, selection
--------------
Or you could import the spreadsheet into a database and then run the query.
|