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
DarylinJ
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

@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.

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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies