excel formulas

[Bill]

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!

 

[akphidelt]

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.

 

[Marcelo]

Also you can try Advanced filter and Pivot table.

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



"akphidelt" escreveu: