You can email me your spreadsheet to:-

.

Steve


"will gerrish" wrote:

Hi,

this is excellent thank you.

im wondering if you can help me with a few tweaks in it? i tidy it up so
that now we have only a Competitor and Result sheet and there is only 1 race.

Competitor sheet is formatted like so

A B C
1 CompetitorNumber SchoolNumber Name
2 1 School1 Bob
3 2 School2 Jim

and so on with 50 competitors

Results Sheet is formatted like so


A B C
D E F
1 Race Number & Positions Time RunnerName RunnerNumber RunnerSchool
2 Cross Country
3 1st #N/A 0
#N/A
4 2nd #N/A 0
#N/A
5 3rd #N/A 0
#N/A
6 4th #N/A 0
#N/A
7 5th #N/A 0
#N/A
8 6th #N/A 0
#N/A


D3 has the VLOOKUP of =VLOOKUP(B3,competitors,3,FALSE)
F3 has the VLOOKUP of =VLOOKUP(B3,competitors,2,FALSE)

whats does the change of 3 and 2 in the vlookups do?

also for some reason i cant seem to get the vlookup to look further than the
orginal 20 lines you created and push further down on to 50 lines.

i can email you the amended spreadsheet if you like?

thanks again for your help.

will


"trip_to_tokyo" wrote:

Hi Will, I have just uploaded a (EXCEL 2007) file to:-

www.pierrefondes.com

- first file at the top of the home page.

1. Look at the Assumptions Worksheet first.

Here you will see an imaginary list of races into which various runners have
been entered.

2. If you then look at the Results Worhsheet this is where I have entered
the results of the various races. (I have done races 100 to 500 for you
inclusive).

It's very rough & very quick but I think it gives you what you want.

It needs a fair amount of tidying up but time prevents me from doing that.

I have checked all the results for races 100 to 500 inclusive and they do
echo back with the right information (runner name, runner number and runner
school).

Please hit Yes if my comments have hekped you.

Thanks!





"will gerrish" wrote:

Hi All,
bit of a strange request but im seeing if anyone's ever done anything like
this or seen something like it on the internet?

Basically, I need a spread sheet that I can input the runners number, name
and school beforehand and then as they run through the finish line, I just
need to put their race number in and the order of their position and their
name and school will automatically come up.

has anyone seen anything like this? or got any ideas of how to go about it?
any help would be great.
thanks
Will