spreadsheet needed
 

HI guys, Iwas wondering if any of those who are familiar with the neural ratings on another site can help me out? I need a spread sheet that will perform certain calculations based on the the neural figures that I would cut and copy from the csv download on thetop of the particular race. It basically involves choosing a best of points across certain catergories. for example the highest points a horse gets out of its course and distance columns would be used and the lower score discarded. hope you understand what I'm getting at. any help at all would be appreciated thanks in advance the doc.

p.s to explain better, best score out of cp, cf and tim columns + best score out of ja,ta and jt columns + bp + best out of crs and dist + $

Dr Ron,

Very easy to do. The function you want to use is MAX().

For example if I wanted the max out of A1, B1, and C1 then I would use

= MAX(A1:C1)

Hope that helps.

If your totally stuck send me an email as I don't check this forum very often anymore. (psmiffy79@aol.com)

Good Luck

Oh and then you have another column that adds the MAX()'s up or you could do that in the same forumular ie :


= MAX(A1:C1) + MAX(D1:E1) + MAX(F1:F1) + MAX(G1:I1)

or howver it corresponds to what you need to max.

Good luck.

Thanks wes much appreciated.