Will in answer to this part:-
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.
1. This is probably because I crated a Range Name in the Worksheet called
Results at cells B12 to D 31 inclusive.
This Range Name was called:-
competitors
2. You either need to extend the Range Name (called competitors) or create a
new Range Name.
3. To create a new Range Name:-
- highlight the cells that you wish to create the Range Name for (for
example cells A 1 to C 10 inclusive
- in the Name Box (the white area just beneath Home / Clipboard) enter the
name of the Range (for example smith)
- hit enter
4. The Range Name:-
smith
- will now have been created.
5. To check that it has been created hit the F5 key and the name:-
smith
- should appear there (if the Range Name has been created properly).
6. Select:-
smith
(in the Go To box) / hit OK / and EXCEL should highlight cells A 1 to C 10
inclusive
So the above should answer your 20 / 50 lines problem.
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