Hi there,

I'm looking for a bit of help on "excel" please. Let's say I have rated every horse in every race at sydney and melbourne following each meeting on a saturday. I've given them all a numerical value which I have determined as a kg value following its run.

All of the horses go into column A and all the ratings go into column B, next to each horse. As you can imagine my columns will start to get very lengthy with hundreds of horses in them. Then next saturday comes along, say Race 1 at sydney and I want to apply my rating for each horse in the race (I wont have all of them, due to horses resuming, coming off provincials etc).

Can I say copy and paste the fields into this spreadsheet, it then finds each horse and allots its rating next to it, or is this asking to much,...!

I know I can do a "find" but that would mean doing each horse individually, is there any faster way.

Thanks and regards
Paul

see how you go with the attached Paul

uses vlookup

file might help

Attached Files

nags_ratings.xls (18.5 KB, 802 views)

thanks Stugots, I am playing around with your formula now. It works excellent on a simple calculation, but when I apply it to my spreadsheet I am getting some number (rating), that is not correct. When I do a fill down, that same incorrect number keeps coming up.

I'm still trying here,

Thanks again, Paul

You need to make sure your Database of horses are listed in alphabetical order.

thanks Moeee, Yes I've done a a-z sort of all the horses, but something is still not working right. Still getting some incorrect number (rating), when its run over a large number of horses. But in a simple example like Stugots sent me, it is working fine.

Thanks again, Paul