Hi. I work for a manufacturer and I need to create a lookup table from our production data that designates the main production line based on which line has the largest amount of volume.
I have the base table created. It looks like this.
The only step I have left is to designate a main line.
In this case, line 25 has the largest volume, so it should be designated with a “YES” as the main line and Line 24 should be designated “NO” (or Blank). However, I’ve been working on this for hours and can’t come to a good solution. I’m afraid I can’t see the forest for the trees at this point.
Does anyone have any ideas about how to do this?