View Single Post
  #5  
Old 6th November 2014, 01:20 PM
jazzy jazzy is offline
Member
 
Join Date: Nov 2010
Posts: 49
Default

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.
Reply With Quote