Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Thread Tools Search this Thread Display Modes
Old 17th January 2009, 10:35 PM
Sparky12 Sparky12 is offline
Join Date: Jan 2006
Posts: 35
Question Excel Help Please

Hello all

I recently purchased Racecensus (and very pleased with it) and am contemplating exporting data to Excel to allow me to produce and test ratings that pre-date my own ratings which go back only as far as 2006.

One problem I reckon I'll face is in the use of the MAX function in Excel which I use to create ratings for specific elements of form. I've attached a very simple example to try and explain things better.

The problem I envisage is that the MAX function is applied to the runners in a specific race only and because each race in the database will have varying numbers of runners, I will need to manually change my MAX formula to accommodate the number of runners (ie: rows) every time I come to a new race in the spreadsheet. A total nightmare I reckon...

If I've explained this OK I was wondering if anyone out there has a solution that would allow the formula to be copied down an entire column in the spreadsheet without the need to manually change it every time there's a change in race?

Any advice would be greatly appreciated - including "don't bother"!!!!

Thanks all

Attached Files
File Type: xls Example Rating1.xls (22.0 KB, 220 views)
Reply With Quote
Old 21st January 2009, 09:43 PM
Sparky12 Sparky12 is offline
Join Date: Jan 2006
Posts: 35
Default Excel problem solved

This issue has now been resolved. If anyone has similar issues I managed to get the answer via a post on - if you look for my post (sparky 12) the formula needed is there.


Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump

All times are GMT +10. The time now is 05:36 PM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655