Apr 29 2019 12:27 AM
i have detail chart with my product details. every product repeat at one table with different kind of values. there is another table without duplicates. i need to get highest value from that first chart from second chart. here attached the details. any one have an idea to sort my issue
Apr 29 2019 02:47 AM
Hii @Ravindu94,
I have solve your issue
but you are using Miscrosoft Office 365/2019 Then use MAXIFS funcation
other your query solve with Sumproduct.
Product | Highest Value | ||||
product1 | 4432 | =MAXIFS($B$4:$B$24,$A$4:$A$24,$G10) | |||
Product2 | 7102 | ||||
Product3 | 7632 |
Product | Highest Value | |
product1 | 4432 | =SUMPRODUCT(MAX(($A$4:$A$24=$G4)*($B$4:$B$24))) |
Product2 | 7102 | |
Product3 | 7632 |
and please find the workbook attachment.
Regards
Shivang