Finding a name in a range and only showing cell contents acr

[jbrown]

I have names in column a and a number across from them in column b. I need a formula to search for a paticular name lets say "smith" and display only the numbers that are associated with smith down column c.
For example:

A B C
brown 1121 2321
smith 2321 2211
conner 2112
smith 2211

Thanks!

 

[Aladin Akyurek]

On 2002-09-21 20:48, jbrown wrote:
I have names in column a and a number across from them in column b. I need a formula to search for a paticular name lets say "smith" and display only the numbers that are associated with smith down column c.
For example:

A B C
brown 1121 2321
smith 2321 2211
conner 2112
smith 2211

Thanks!

Can you sort the data on names?

 

[jbrown]

yes the numbers are random.

 

[Aladin Akyurek]

On 2002-09-21 21:21, jbrown wrote:
yes the numbers are random.

The question is: Are you willing to sort your data on the names column?

 

[Yogi Anand]

Hi jbrown:

One of the ways you can do this is by using Advanced Filter. See the worksheet simulation ...

y020921.xls
	A	B	C	D	E	F	G	H
1	solutionusingAdvancedFilter				Name			source
2					smith			criterion
3								output
4	Name	ColB	ColC		ColC
5	brown	1121	2321		2211
6	smith	2321	2211
7	conner	2112
8	smith	2211
Sheet15

</SPAN>

Regards!

Yogi