excel formulas

  • Thread starter Thread starter Bill
  • Start date Start date
B

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!
 
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.
 
Also you can try Advanced filter and Pivot table.

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



"akphidelt" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel formula 5
Table names in formulas in Excel 2007 1
Find highest value in a specific data set. 6
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Lookup the 3rd Value 1
Excel formula help, No VBA please 1
SIMPLE FORMULA 6
Defined Range Names in formulas 2

Back
Top