matching and lookup??
Assuming your data starts in A2, with the headers in row 1, and the Item# is
in D1, use this array formula - entered with Shift+Ctrl+Enter =SUMPRODUCT(--(B2:B8=D1),--(C2:C8=MAX(IF(B2:B8=D1,C2:C8,0))),A2:A8) "eoht" wrote: Job # Item # Quantity 51 100 10 85 105 9 64 103 8 78 103 3 45 100 7 53 101 9 24 101 6 I'm trying to find a function that will let me find the "Job #", by matching the "Item #" and the max number of "Quantity" used. For example, if I know that "Item#" = 100 has a max. of 10 quanities used, I want to find a function that will let me find the "Job #" of that quantity and Item # is 51. Any Suggestions? |
All times are GMT +1. The time now is 03:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com