excel formulas
 

I have an excel fine with data both text and numbers against different names.
What i want is to find a formula that can collect all the data against a
specific name provided as condition in a formula. For Example

Column A Column B Column C
Jeff 123 USA
Bill 223 UK

If i enter the condition for "Bill" the formula shows us all the fields
against this name.

Need Help!

excel formulas
 

Try highlighting row 1. Click on Data---Filter--AutoFilter

This will turn autofiltering on. Then you can use those drop down boxes to
select the criteria you want it will show you only the data that matches.

"Bill" wrote:

I have an excel fine with data both text and numbers against different names.
What i want is to find a formula that can collect all the data against a
specific name provided as condition in a formula. For Example

Column A Column B Column C
Jeff 123 USA
Bill 223 UK

If i enter the condition for "Bill" the formula shows us all the fields
against this name.

Need Help!

excel formulas
 

Also you can try Advanced filter and Pivot table.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"akphidelt" escreveu:

Try highlighting row 1. Click on Data---Filter--AutoFilter

This will turn autofiltering on. Then you can use those drop down boxes to
select the criteria you want it will show you only the data that matches.

"Bill" wrote:

I have an excel fine with data both text and numbers against different names.
What i want is to find a formula that can collect all the data against a
specific name provided as condition in a formula. For Example

Column A Column B Column C
Jeff 123 USA
Bill 223 UK

If i enter the condition for "Bill" the formula shows us all the fields
against this name.

Need Help!