Home

How do I extract data from one sheet to another, depending on a numerical ranking system?

%3CLINGO-SUB%20id%3D%22lingo-sub-815494%22%20slang%3D%22en-US%22%3EHow%20do%20I%20extract%20data%20from%20one%20sheet%20to%20another%2C%20depending%20on%20a%20numerical%20ranking%20system%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815494%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20all%2C%20I've%20got%20a%20screenshot%20below%20to%20illustrate%20what%20I'm%20working%20with.%20But%20here's%20the%20situation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20the%20left-hand%20window%20(step%20three)%2C%20I%20have%20a%20series%20with%20a%201-5%20ranking%20system%20in%20the%20next%20column%20over.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20goal%20is%20to%20have%20the%20sheet%20on%20the%20right-hand%20side%20of%20the%20screen%26nbsp%3B(step%20four)%20display%20any%20of%20those%20traits%20that%20have%20a%20ranking%20of%203%2C%204%2C%20or%205.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20I%20don't%20have%20the%20slightest%20idea%20how%20to%20make%20a%20formula%20that%20will%20output%20that.%20I%20apparently%20don't%20even%20know%20enough%20about%20Excel%20to%20intelligently%20search%20for%20it%2C%20because%20my%20research%20hasn't%20turned%20up%20a%20thing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127861iBEF5C340B987450C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel.PNG%22%20title%3D%22Excel.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-815494%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815928%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20extract%20data%20from%20one%20sheet%20to%20another%2C%20depending%20on%20a%20numerical%20ranking%20system%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815928%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396095%22%20target%3D%22_blank%22%3E%40aspireworks%3C%2FA%3E%26nbsp%3BYou'll%20be%20much%20better%20off%20if%20you%20can%20structure%20your%20data%20in%20a%20flat-file%20(think%20database)%20type%20structure%2C%20and%20keep%20all%20your%20entries%20on%20one%20sheet%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EName%20%7C%20Trait%20%231%20%7C%20Trait%20%232%20%7C%20Trait%203%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20there%20you%20can%20use%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FCreate-a-PivotTable-to-analyze-worksheet-data-A9A84538-BFE9-40A9-A8E9-F99134456576%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPivotTables%3C%2FA%3Eto%20summarize.%20As%20you%20add%2Fremove%20data%2C%20just%20refresh%20the%20PivotTables%20to%20see%20the%20newest%20updates.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHTH%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-816266%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20extract%20data%20from%20one%20sheet%20to%20another%2C%20depending%20on%20a%20numerical%20ranking%20system%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816266%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396095%22%20target%3D%22_blank%22%3E%40aspireworks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20attached%20example%20for%20you%2C%20I%20have%20used%20the%20if%20function%20and%20told%20it%20to%20pull%20through%20to%20the%20step%20four%20sheet%20any%20trait%20that%20has%20a%20value%20higher%20than%202%20(%26gt%3B2).%3C%2FP%3E%3C%2FLINGO-BODY%3E
aspireworks
Occasional Visitor

Hey all, I've got a screenshot below to illustrate what I'm working with. But here's the situation.

 

On the left-hand window (step three), I have a series with a 1-5 ranking system in the next column over. 

 

My goal is to have the sheet on the right-hand side of the screen (step four) display any of those traits that have a ranking of 3, 4, or 5.

 

But I don't have the slightest idea how to make a formula that will output that. I apparently don't even know enough about Excel to intelligently search for it, because my research hasn't turned up a thing.

 

Any suggestions?

Excel.PNG

2 Replies

@aspireworks You'll be much better off if you can structure your data in a flat-file (think database) type structure, and keep all your entries on one sheet:

 

Name | Trait #1 | Trait #2 | Trait 3

 

From there you can use PivotTables to summarize. As you add/remove data, just refresh the PivotTables to see the newest updates.

 

HTH

Hi @aspireworks 

 

Please see attached example for you, I have used the if function and told it to pull through to the step four sheet any trait that has a value higher than 2 (>2).

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