Forum Discussion
Selo46
Jun 30, 2022Copper Contributor
Excel - help me please
Hello, I want to know what formula I need when there is a list of duplicate different manufacturers and a number of duplicate different parts and I want to determine the manufacturer and next to it ...
OliverScheurich
Jun 30, 2022Gold Contributor
=SUM(N(IF($A$1:$A$24=D4,MATCH(IF($A$1:$A$24=D4,$B$1:$B$24),IF($A$1:$A$24=D4,$B$1:$B$24),0)=ROW($1:$24))))If you don't work with Office365 or 2021 you can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
If you work with Office365 or 2021 an easier alternative could be with the UNIQUE function.