"My mistake regarding including Target values, that filter should have been included in the pivot table (you could do it yourself by fitering Attribute for only Production)."




I dont know how. im really novice in pivot table.


"there are many instances where 2 machines produced the same Max (operator 101833 on 2/2/2023 produced the max of 80 on both machines A3 and A4). What do you want to see?"


Yes. if there a match, it will show only one. the production i gave on those sheet are all the copy/paste. real one match is quite rare.


"Your last column Total Produc will only show the sum of the machines which produced the max (ignoring all other machines); is this really what you want to see?"


Yes.

"And one more important thing, which version of Excel are you using? Does it have available such functions on the worksheet as FILTER, TOCOL and XMATCH? "


im using windows 10, office 2019. normal filter is avaiable. but i dont know about "TOCOL and XMATCH". i cant install addons or any software on this pc (locked down by IT dept.).


Your solution is perfect. just ignore 2nd machine number. and add total in the end. that will do. many thanks to you

Attached Images

Screenshot 2023-06-23 084014.jpg (92.0 KB, 31 views)