Can a spreadsheet do this ?

%3CLINGO-SUB%20id%3D%22lingo-sub-2172706%22%20slang%3D%22en-US%22%3ECan%20a%20spreadsheet%20do%20this%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2172706%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BSo%20I%20am%20trying%20to%26nbsp%3B%20make%20a%20spreadsheet%20on%20the%20heroes%20of%20a%20game.%20I%20want%20to%20make%20a%20list%20of%20all%20the%20possible%203%20hero%20combinations%20ranked%20from%20best%20to%20worse%2C%20the%20user%20will%20select%20the%20heroes%20he%20owns%20in%20the%20game%20and%20the%20spreadsheet%20should%20show%20him%20all%20the%20possible%203%20hero%20combinations%20he%20can%20have%20from%20the%20heroes%20he%20selected%20ranked%20best%20to%20worse%2C%20depending%20on%20the%20list%20that%20I%20implemented%20in%20the%20spreadsheet.%20Can%20it%20be%20done%20or%20does%20such%20a%20thing%20need%20programming%20%3F%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2172706%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
Occasional Visitor

Hi guys,

 

 So I am trying to  make a spreadsheet on the heroes of a game. I want to make a list of all the possible 3 hero combinations ranked from best to worse, the user will select the heroes he owns in the game and the spreadsheet should show him all the possible 3 hero combinations he can have from the heroes he selected ranked best to worse, depending on the list that I implemented in the spreadsheet. Can it be done or does such a thing need programming ? Thank you

1 Reply
if I can recommend you, add a MS Excel file (without sensitive data) to your project.
Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
Please no picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

* Knowing the Excel version and operating system would also be an advantage.

Thank you for your understanding and patience


Nikolino

I know I don't know anything (Socrates)