hello everyone, URGENT HELP
need your help in finding a formula..
i have a very large database where i have more than 1000 product and 500 customer .. i need to know what products are listed/sold by each customer .. i have used count-if and count-ifs but it is giving me repeated product ... for eg: luna has 20 product so i need to know 111 customer is selling how many luna product?
<tbody>
</tbody>
need your help in finding a formula..
i have a very large database where i have more than 1000 product and 500 customer .. i need to know what products are listed/sold by each customer .. i have used count-if and count-ifs but it is giving me repeated product ... for eg: luna has 20 product so i need to know 111 customer is selling how many luna product?
Customer code | Product code | Brand | Product | |||||
111 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> | ABC |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> | XXX |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> | Luna |
<tbody> </tbody> |
<tbody>
</tbody>