How to segregate data lines based on percentage automatically?

uwish7

New Member
Joined
Jul 26, 2017
Messages
26
Hello. I am trying to take the percentage based on plant and material number and segregate the handling units to two different plants. For example, in the information below, I want excel to look at another worksheet. if the plant and material match, plant 1 will get 20% of the total 5,801 and plant 2 will get 80% of the total.
Handling unit Total
1234
4567 5801

I was thinking of writing a macro, but I am not that advanced to do that.
 

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,615
Hello

Can you not just use an IF formula i.e. It the two values are the same then multiply total by 20%. Then calculate the difference for the other part. Or am I missing something? You may need a clearer description of the problem.
 

Forum statistics

Threads
1,085,536
Messages
5,384,294
Members
401,887
Latest member
Somesh

Some videos you may like

This Week's Hot Topics

Top