VLOOKUP with max value
Hi,
as you can see in the attachment, i have a bonus sheet at 1st from then each sheet label corresponds to work date. in the bonus sheet i want to add all the production and machine number of each production day. so i did it with VLOOKUP function.
At A4 cell is a id of a operator. that id is placed in different/same machine in a production day (if he was present). as you can see he was available at 01-02-23 sheet, he was placed in machine a1 & a2, his produced 80kg & 90kg with both of those machine. and so on. some times A operator can run 2 machine, someday 1 machine.
now here is the problem. my formula took A1 and production 80kg since its 1st in order. but I want to add his max produced machine and production which is A2 & 90kg. how do i do that?
|