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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 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
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies