Win summary of products per seller

[makinmomb]

Formula on N2 to drag down , cell K can be changed from SELLER 1 to another SELLER say SELLER 2

If the formula works correctly it will plug 4 and 1 on n2 and n3 since seller 1 was fourth for product 100 and First for Product 101

[samba_ravi]

=IFERROR(MATCH($K$2,INDEX($B$2:$I$10,MATCH($L2,$A$2:$A$10),),0),"")

Please Login or Register  to view this content.

try the above in N2 and copy towards down

[makinmomb]

Yeah working and tested by changing seller names , works too

Thank you

[samba_ravi]

Thanks for your feedback