Hi,
I have two columns 300+ rows long. One (A) contains names. One (B) contains
single digit numbers; either 1 or 2 or 3, etc. through number 8.
What I would like to do is type in a name in, lets say (C10) that would
return EVERY number in column (B) that was next to that name. If I type
in(C10) Donald Getts and this name appears 20 times in (A) I need the 20
numbers that are in column (B) next to Donald Getts.
Of course I need the numbers separated by a comma or have them appear in
separate cells would be better yet.
Sorry to drabble on but I see so many questions here that are harder to
decipher than the answers provided.

Thank you, Ken Williams

Use the AutoFilter functionality

Make sure you have a column heading for each of the two columns

With any cell in your 'database' active, select Data | Filter | Autofilter
from the menu. This will add little drop down arrows next to each column
heading.

Click on the drop down arrow for the names and select Donald Getts from the
list. Excel will filter the table to show every occurrence of his name, and
the associatiated numbers. Just highlight & copy/paste the numbers to a new
location



"Ken" wrote:

Hi,
I have two columns 300+ rows long. One (A) contains names. One (B) contains
single digit numbers; either 1 or 2 or 3, etc. through number 8.
What I would like to do is type in a name in, lets say (C10) that would
return EVERY number in column (B) that was next to that name. If I type
in(C10) Donald Getts and this name appears 20 times in (A) I need the 20
numbers that are in column (B) next to Donald Getts.
Of course I need the numbers separated by a comma or have them appear in
separate cells would be better yet.
Sorry to drabble on but I see so many questions here that are harder to
decipher than the answers provided.

Thank you, Ken Williams

Ken wrote:
Hi,
I have two columns 300+ rows long. One (A) contains names. One (B) contains
single digit numbers; either 1 or 2 or 3, etc. through number 8.
What I would like to do is type in a name in, lets say (C10) that would
return EVERY number in column (B) that was next to that name. If I type
in(C10) Donald Getts and this name appears 20 times in (A) I need the 20
numbers that are in column (B) next to Donald Getts.
Of course I need the numbers separated by a comma or have them appear in
separate cells would be better yet.
Sorry to drabble on but I see so many questions here that are harder to
decipher than the answers provided.

Thank you, Ken Williams


If the functions in the file at http://home.pacbell.net/beban are
available to your workbook you can enter the folowing in a cell and fill
it down to accommodate the largest number of numbers you will have for a
name:

=INDEX(Vlookups(F$1,A$1:B$400,2),ROW(A1))

Alan Beban

Thank you. I will try these and report back.
Ken


"Ken" wrote in message
link.net...
Hi,
I have two columns 300+ rows long. One (A) contains names. One (B)
contains single digit numbers; either 1 or 2 or 3, etc. through number 8.
What I would like to do is type in a name in, lets say (C10) that would
return EVERY number in column (B) that was next to that name. If I type
in(C10) Donald Getts and this name appears 20 times in (A) I need the 20
numbers that are in column (B) next to Donald Getts.
Of course I need the numbers separated by a comma or have them appear in
separate cells would be better yet.
Sorry to drabble on but I see so many questions here that are harder to
decipher than the answers provided.

Thank you, Ken Williams

Thank you for this information. Taking it one step more... is it possible
for me to add names and corresponding numbers to the existing list using
this Auto Filtering?

If not, is there another method/formula to do so.

Thanks, Ken


"Duke Carey" wrote in message
...
Use the AutoFilter functionality

Make sure you have a column heading for each of the two columns

With any cell in your 'database' active, select Data | Filter | Autofilter
from the menu. This will add little drop down arrows next to each column
heading.

Click on the drop down arrow for the names and select Donald Getts from
the
list. Excel will filter the table to show every occurrence of his name,
and
the associatiated numbers. Just highlight & copy/paste the numbers to a
new
location



"Ken" wrote:

Hi,
I have two columns 300+ rows long. One (A) contains names. One (B)
contains
single digit numbers; either 1 or 2 or 3, etc. through number 8.
What I would like to do is type in a name in, lets say (C10) that would
return EVERY number in column (B) that was next to that name. If I type
in(C10) Donald Getts and this name appears 20 times in (A) I need the 20
numbers that are in column (B) next to Donald Getts.
Of course I need the numbers separated by a comma or have them appear in
separate cells would be better yet.
Sorry to drabble on but I see so many questions here that are harder to
decipher than the answers provided.

Thank you, Ken Williams