Help! include a loss % linked with matching reference

%3CLINGO-SUB%20id%3D%22lingo-sub-2232118%22%20slang%3D%22en-US%22%3EHelp!%20include%20a%20loss%20%25%20linked%20with%20matching%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2232118%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys!%3C%2FP%3E%3CP%3Ei%20am%20hoping%20someone%20has%20an%20idea%20to%20what%20i%20could%20use!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emy%20spreadsheet%20isn't%20perfect%20but%20its%20functional%20to%20what%20i%20need%20(at%20the%20moment)%3C%2FP%3E%3CP%3Eso%20to%20give%20you%20an%20idea%20see%20bullet%20point%20below%20and%20any%20suggestions%20please%20let%20me%20know%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Espreadsheet%20is%20for%20stock%20reconciliation%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20material%20comes%20in%20it%20has%20a%20reference%20e.g%20MAI14555%2024%2C300kg%3C%2FP%3E%3CP%3Ewhen%20material%20goes%20out%20in%20parts%20(not%20all%20qty%20in%20one%20go)%20it%20will%20go%20against%20MAI14555%20(multiple)%26nbsp%3B%20and%20leave%20a%20balance%20of%20material%20from%20total%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20want%20to%20show%20once%20all%20the%20material%20has%20gone%20out%20what%20the%20loss%20is%20in%20a%20%25%20which%20i%20can%20but%20i%20need%20it%20too%20link%20to%20MAI14555%20that%20isn't%20necessarily%20in%20the%20same%20row!%20see%20attached%20so%20it%20makes%20a%20lil%20more%20sense%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Elet%20me%20know%20best%20method%20-%20it%20need%20to%20link%20reoccurring%20reference%20(in%20difference%20places)%20with%20original%20total%20weight%20with%20what's%20left%20over%20but%20as%20a%20%25%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2232118%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi Guys!

i am hoping someone has an idea to what i could use!

 

my spreadsheet isn't perfect but its functional to what i need (at the moment)

so to give you an idea see bullet point below and any suggestions please let me know:

 

spreadsheet is for stock reconciliation 

when material comes in it has a reference e.g MAI14555 24,300kg

when material goes out in parts (not all qty in one go) it will go against MAI14555 (multiple)  and leave a balance of material from total 

 

i want to show once all the material has gone out what the loss is in a % which i can but i need it too link to MAI14555 that isn't necessarily in the same row! see attached so it makes a lil more sense 

 

let me know best method - it need to link reoccurring reference (in difference places) with original total weight with what's left over but as a % 

0 Replies