can anyone help me to solve my 2 excel problems,
First one I have a pcking list which have 7 checklist(CL) like the example below
Packing CL1 CL2 CL3 CL4 CL5 CL6 CL7 Score
Now if all 7CL's are yes available then the score will be 100%, if 6CL's available the score will be 85.71% ((100/7)*6), if 5CL's available then the score will be 71.42% ((100/70*5) and like that.
Second problem, liking it with the first one I might have more than one packings in a shipment like example below
shipment 1 CL1 CL2 CL3 CL4 CL5 CL6 CL7 Score
Total Shipment 1
Shipment 2 CL1 CL2 CL3 CL4 CL5 CL6 CL7 Score
Total Shipment 2
is there a formula like when once i finish with packing 1 the next below cell will let me choose packing 2 or total in order to decrease manual job, total will be the sum of yes's per CL's in order to have the average score.
Thanks everyone in advanced for your help, and looking for the solutions soon :)