find a name from a list then extract it

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

Guest

This is for winners of a hole in golf. I have a list of 48 names in column a.
I pull out a possible 18 winners in another column. There is very seldom all
18 winners so there is blank rows in between the winners. I would like to
just pull out the winners and put them together without missing rows.
column
a b
jeff jeff
jay " "
kevin kevin
tom tom
jim " "
I would like another column to just show the winners jeff, kevin, tom.
The names and amount of winners will be different for every round.
 
Perhaps you could sort the column of winners so blanks go to the
bottom of the list
 
I have a winners sheet listing the hole winners. I want to put all the
winners together and how much they won. If a person won more than one hole I
have to add those together. After I post the scores I want the sheet to
automatically be updated.
 
You must log in or register to reply here.

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

Deriving winners from a list 4
Pick a Random name from a list. 8
counting cells in a row with color highlight 9
Formulas 1
How do I pull a name out of a list - randomly? 6
Sort winners of a golf tournament two ways 15
getting name value in cell from If formula 5
Transposing Question 6

Back
Top