Hi everyone,
I'm struggling with my data that does not give the result I want, could you please help me?
Capture.PNG
How to get 10 (on column 'unit' or column B) for item code 1172 (as 10, is the smallest total unit for 1172)?
How to get -20 (on column 'unit' or column B) for item code 1856 (as -20, is the smallest total unit for 1856)?
I've tried =MIN(B2:B9,INDEX(B2:B9,MATCH(C2,A2:A9,0))) but the result is -20
I've tried =SMALL(INDEX(B2:B9,MATCH(C2,A2:A9,0),0),ROWS(1:1)) but the result is 12
Thank you so much for your help, really appreciate it.
-Melissa-
Bookmarks