Is there a way to balance data for a game in a table containin

%3CLINGO-SUB%20id%3D%22lingo-sub-2158790%22%20slang%3D%22en-US%22%3EIs%20there%20a%20way%20to%20balance%20data%20for%20a%20game%20in%20a%20table%20containin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2158790%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20have%20a%20table%20containing%20balancing%20data%20for%20a%20game.%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E**DAY%20**(Column%20C)%20is%20generated%20from%20a%20formula%2C%20and%20contains%20required%20durations%20to%20be%20spent%20to%20complete%20each%20**LEVEL%20**(Column%20B).%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ENow%20I%20need%20to%20track%20back%20**LEVEL%20**(Column%20F)%20from%20**DAY%20**(Column%20E).%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3EProblem%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdrive.google.com%2Ffile%2Fd%2F17T273k2vV5SCX8PiORF-HFvfQnx5ayMK%2Fview%3Ffbclid%3DIwAR3mzEQYJd4WEwSsbkY53cRzLxvj4E24Y5zUbLjHU0cFh2jdQa2VqphuvBs%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EHere%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EWhat%20i%20want%20to%20do%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsheet.zoho.com%2Fsheet%2Fofficeapi%2Fv1%2F4ffe72baff560e0fbcb01374760e87f6d27f5d5b287a5fc13c1b7be4ab8b54410555190cee516a612ed07add296ba14c7bd0a9d1daa2f9a33f9f4d8ae56d556f%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EHere%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F963588%22%20target%3D%22_blank%22%3E%40IlirU%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2158790%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2158810%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20way%20to%20balance%20data%20for%20a%20game%20in%20a%20table%20containin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2158810%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F406165%22%20target%3D%22_blank%22%3E%40Edo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20you%20explain%20in%20detail%20what%20you%20want%20in%20column%20F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2158815%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20way%20to%20balance%20data%20for%20a%20game%20in%20a%20table%20containin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2158815%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a table containing balancing data for a game.

**DAY **(Column C) is generated from a formula, and contains required durations to be spent to complete each **LEVEL **(Column B).

Now I need to track back **LEVEL **(Column F) from **DAY **(Column E).

Problem Here  
What i want to do Here 

@Hans Vogelaar @Subodh_Tiwari_sktneer @IlirU 

5 Replies

@Edo 

Can you explain in detail what you want in column F?

I need to track back **LEVEL **(Column F) from **DAY **(Column E).

@Edo You will have to be more specific than that.

For example, how does one arrive at 2.2 for day 1, or at 3.5 for day 2? Please provide some details

@Edo 

 

Can you upload the files here itself? The links you provided didn't work for me.