Home

Selecting specific info from a table

%3CLINGO-SUB%20id%3D%22lingo-sub-827489%22%20slang%3D%22en-US%22%3ESelecting%20specific%20info%20from%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-827489%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20new%20to%20Excel.%20I%20have%20taken%20a%20class%2C%20but%20I%20still%20feel%20so%20new%20at%20implementing%20what%20I've%20learned.%20My%20question%20seems%20so%20simple%2C%20but%20I%20am%20having%20a%20hard%20time%20trying%20to%20figure%20it%20out%2C%20I'd%20appreciate%20any%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20of%20contractors%20and%20their%20order%20information%20in%20rows.%20How%20can%20I%20pull%20out%20a%20narrowed%20list%20of%20individual%20contractors%20and%20all%20of%20their%20order%20information%20(multiple%20columns%20of%20info)%3F%20I%20have%20seen%20how%20this%20can%20be%20done%20in%20Access%20and%20Google%20Sheets%20with%20a%20Query%20function.%20How%20do%20I%20do%20it%20in%20Excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-827489%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-827625%22%20slang%3D%22en-US%22%3ERe%3A%20Selecting%20specific%20info%20from%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-827625%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399706%22%20target%3D%22_blank%22%3E%40DarylinJ%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20multiple%20ways%20to%20achieve%20that%20and%20it%20depends%20on%20you%20that%20which%20method%20you%20are%20comfortable%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20You%20can%20have%20a%20dropdown%20list%20of%20all%20the%20Contractors%20in%20a%20Cell%20on%20another%20worksheet%2C%20place%20the%20header%20of%20all%20the%20columns%20of%20your%20data%20in%20an%20empty%20row%20and%20then%20use%20an%20Array%20Formula%20Index%2FSmall%20to%20pull%20all%20the%20related%20data%20for%20the%20contractor%20you%20selected%20in%20the%20dropdown.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20You%20can%20use%20Advanced%20Filter%20to%20either%20copy%20the%20data%20related%20to%20a%20specific%20contractor%20to%20another%20location%20or%20filter%20the%20data%20in%20place.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3)%20If%20your%20data%20is%20formatted%20as%20an%20Excel%20Table%2C%20you%20can%20insert%20a%20Slicer%20based%20on%20the%20Contractor%20field%20and%20if%20you%20select%20a%20contractor%20from%20the%20Slicer%2C%20the%20table%20will%20display%20the%20data%20related%20to%20the%20selected%20contractor%20in%20the%20Slicer.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-827879%22%20slang%3D%22en-US%22%3ERe%3A%20Selecting%20specific%20info%20from%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-827879%22%20slang%3D%22en-US%22%3E%3CP%3EI%20used%20the%20Advanced%20Filter%20and%20it%20worked%20great.%3C%2FP%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EBecause%20I'm%20a%20newbie%2C%20I%20did%20need%20to%20click%20on%20the%20help%20icon%20in%20the%20Advanced%20Filter%20dialog%20box%20and%20it%20walked%20me%20through%20the%20process%20easily.%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EThanks%20for%20pointing%20me%20in%20the%20right%20direction!%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-828112%22%20slang%3D%22en-US%22%3ERe%3A%20Selecting%20specific%20info%20from%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-828112%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399706%22%20target%3D%22_blank%22%3E%40DarylinJ%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20welcome!%20Glad%20I%20could%20help.%3C%2FP%3E%3CP%3EYou%20may%20close%20your%20question%20now%20after%20accepting%20my%20post%20as%20an%20answer%20if%20it%20was%20helpful%20to%20resolve%20your%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am new to Excel. I have taken a class, but I still feel so new at implementing what I've learned. My question seems so simple, but I am having a hard time trying to figure it out, I'd appreciate any help.

 

I have a table of contractors and their order information in rows. How can I pull out a narrowed list of individual contractors and all of their order information (multiple columns of info)? I have seen how this can be done in Access and Google Sheets with a Query function. How do I do it in Excel?

3 Replies
Highlighted

@DarylinJ 

 

There are multiple ways to achieve that and it depends on you that which method you are comfortable with.

 

1) You can have a dropdown list of all the Contractors in a Cell on another worksheet, place the header of all the columns of your data in an empty row and then use an Array Formula Index/Small to pull all the related data for the contractor you selected in the dropdown.

 

2) You can use Advanced Filter to either copy the data related to a specific contractor to another location or filter the data in place.

 

3) If your data is formatted as an Excel Table, you can insert a Slicer based on the Contractor field and if you select a contractor from the Slicer, the table will display the data related to the selected contractor in the Slicer.

Highlighted

I used the Advanced Filter and it worked great.

 
Because I'm a newbie, I did need to click on the help icon in the Advanced Filter dialog box and it walked me through the process easily. 
 
Thanks for pointing me in the right direction! 

@DarylinJ 

 

You're welcome! Glad I could help.

You may close your question now after accepting my post as an answer if it was helpful to resolve your issue.

Related Conversations
[Info] Surface Duo SDK Version 02022020 is out!
tscholze in Surface Duo SDK on
0 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
PWA fullscreen like IE11 kiosk mode
rogihee in Discussions on
5 Replies
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies