Find a group of names in a long list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Okay, I help score a racing series. There are 200 people in the series and I
have their names in an Excel spreadsheet. After every race I have to go
through the results (typically 200 to 600 names) and find anyone who is
signed up for the series. Usually there are about 70 people in the series at
each race. There is nothing in the race results to indicate they are in the
series besides their names.
I've been doing this manually, but wondered if I could copy/paste the list
of names from the individual race results and then have Excel automatically
pull out the names which match from my series roster.
Is this possible with excel?
 
It sound like you need to use a VLOOKUP or HLOOKUP. Without more details
about the data you;re trying to get out, or what your sheet looks like, I'd
suggest looking at the excel helpfile on these 2 functions.

HTH.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'auto find average of 4 fastest times' 3
how to unlink links copied from a list from the internet 2
My Steam Games installed 7
Searching or Find question 5
Ranking a list 4
Whites To Be A Minority in the U.S. in decades. 3
Whites To Be A Minority in the United States in decades. 1
Accumulating Multiple Inputs From a Single Cell 4

Back
Top