| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a name from a list then extract it
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find a name from a list then extract it
Perhaps you could sort the column of winners so blanks go to the
bottom of the list On Jan 30, 2:46 pm, JPreeshl wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find a name from a list then extract it
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. "Lori" wrote: Perhaps you could sort the column of winners so blanks go to the bottom of the list On Jan 30, 2:46 pm, JPreeshl wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced filter and a list | New Users to Excel | |||
| find sum in list of of numbers | New Users to Excel | |||
| Extract each item in the list | Excel Worksheet Functions | |||
| find next number in list | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Linear Mode
