Here's a quick example I put together:
http://www.kan.org/tips/files/ride_roster_example.xls

You can create an entry area (up to 5 numbers in my example) and then use a
VLOOKUP to match those ride numbers with a specific rider. I use an
IF-ISERROR to turn those into "1's" and blanks. Using the Autofilter, you
can just filter for the 1's. You could also write a quick macro to clear the
5 names in prep for the next group of riders
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"excelneophyte" wrote:

A have a list of participants in a charity cycling event that are all listed
in excel in order of their ride number. Their names and hometowns are in
adjacent columns.

I have a spotter 200y up from the finish who radios back to me at the
finish, the next group of riders about to finish.

Say for instance, 4 riders come around the corner together.... say 36, 49,
23, 11.... is there a way when they radio those numbers to me, that I can
quickly access all 4 of them in that group (in some type of list) so I can
announce their names as they cross the line? Or do I need to look up each
race number individually?

If it can't be done in an excel document, could it be done in some other
type of data filing program?

Thanks for any help....