Home

Assigning values to a set number of cells

%3CLINGO-SUB%20id%3D%22lingo-sub-901696%22%20slang%3D%22en-US%22%3EAssigning%20values%20to%20a%20set%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901696%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20a%20formula%20that%20will%20take%20a%20data%20that%20has%20values%20assigned%20to%20them%20and%20arrange%20it%20on%20set%20up%20cells%20in%20order.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EExample%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eq%20-%207%3C%2FP%3E%3CP%3Ew%20-%204%3C%2FP%3E%3CP%3Ee%20-%206%3C%2FP%3E%3CP%3Er%20-%208%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20it%20to%20read%20that%20and%20then%20arrange%20in%20cells%20in%20a%20set%20range%20of%20cells%20(lets%20say%2016%20x%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CLI-EMOJI%20id%3D%22lia_smiling-face-with-sunglasses%22%20title%3D%22%3Asmiling_face_with_sunglasses%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%207%20cells%20with%20a%20q's%2C%20then%204%20cells%20with%20a%20w%2C%20then%206%20with%20an%20e%2C%20etc.%20Is%20this%20even%20possible%2C%20I%20feel%20like%20it%20is%20but%20cant%20figure%20it%20out.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-901696%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-904304%22%20slang%3D%22en-US%22%3ERe%3A%20Assigning%20values%20to%20a%20set%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-904304%22%20slang%3D%22en-US%22%3Esounds%20interesting%20but%20I%20couldn't%20figure%20out%20what%20exactly%20you%20need.%20Also%20looked%20at%20the%20file%20but%20I'm%20still%20struggling%20to%20understand%20the%20requirement.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-906868%22%20slang%3D%22en-US%22%3ERe%3A%20Assigning%20values%20to%20a%20set%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-906868%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422787%22%20target%3D%22_blank%22%3E%40aworral0811%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20recommend%20that%20you%20manually%20enter%20your%20desired%20results%20and%20explain%20the%20logic%20thereof.%20It%20is%20such%20logic%20that%20dictates%20the%20formula%20to%20return%20your%20desired%20results.%20Needless%20to%20say%2C%20you%20won't%20obtain%20any%20suggested%20formula%20without%20your%20explanation%20of%20the%20logic%20of%20your%20desired%20results%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
aworral0811
Occasional Visitor

I need a formula that will take a data that has values assigned to them and arrange it on set up cells in order.  

Example:

 

q - 7

w - 4

e - 6

r - 8

 

I need it to read that and then arrange in cells in a set range of cells (lets say 16 x   7 cells with a q's, then 4 cells with a w, then 6 with an e, etc. Is this even possible, I feel like it is but cant figure it out. 

 

Any help would be appreciated! 

2 Replies
sounds interesting but I couldn't figure out what exactly you need. Also looked at the file but I'm still struggling to understand the requirement.

@aworral0811 

I recommend that you manually enter your desired results and explain the logic thereof. It is such logic that dictates the formula to return your desired results. Needless to say, you won't obtain any suggested formula without your explanation of the logic of your desired results, 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies