match
 

Note I mistakenly posted this in "excel.misc". Not trying to cross post.
Sorry.

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

See replies in .misc

Biff

-----Original Message-----
Note I mistakenly posted this in "excel.misc". Not trying
to cross post.
Sorry.

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


.

I did. Thank you.
Ken


"Ken" wrote in message
hlink.net...
Note I mistakenly posted this in "excel.misc". Not trying to cross post.
Sorry.

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