find a name from a list then extract it

J

JPreeshl

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.
 
J

JPreeshl

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.
 

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

Top