Unique Manufacturers

[soumen21]

Hi Experts,

I have some data as shown in the spreadsheet.

I want to find the number of manufacturers (manufacturer should not be repeated)
and the also the minimum number associated with the Part Number in another cell.

Part Number	Mfr. Name	Number
AACBBBCC	ASJ PTE LTD	3	Total Number of unique manufacturers for AACBBBCC	?
AACBBBCC	CAL-CHIP ELECTRONICS INC	2
AACBBBCC	KOA SPEER ELECTRONICS INC	1	Minimum Number of AACBBBCC	?
AACBBBCC	KOA SPEER ELECTRONICS INC	4
AACBBBCC	KOA SPEER ELECTRONICS INC	5
AACBBBCC	KOA SPEER ELECTRONICS INC	6
AACBBBCC	KOA SPEER ELECTRONICS INC	3
AACBBBCC	KOA SPEER ELECTRONICS INC	2
AACBBBCC	KOA SPEER ELECTRONICS INC	1
AACBBBCC	KOA SPEER ELECTRONICS INC	4
AACBBBCC	KOA SPEER ELECTRONICS INC	5
AACBBBCC	MERITEK	6
AACBBBCC	MERITEK	3
AACBBBCC	MERITEK	2
AACBBBCC	NIC COMPONENTS CORP	1
AACBBBCC	NIC COMPONENTS CORP	4
AACBBBCC	RCD COMPONENTS INC	5
AACBBBCC	ROHM CORP	6
AACBBBCC	SEI ELECTRONICS	3
AACBBBCC	SEI ELECTRONICS	2
AACBBBCC	SEI ELECTRONICS	1

Could you please help.

Regards
Soumen

 

[Fluff]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

 

[soumen21]

Microsoft Excel version 2019

 

[Fluff]

Ok, how about

+Fluff New.xlsm
	A	B	C	D	E
1	Part Number	Mfr. Name	Number
2	AACBBBCC	ASJ PTE LTD	3	AACBBBCC
3	AACBBBCC	CAL-CHIP ELECTRONICS INC	2	Total Number of unique manufacturers	8
4	AACBBBCC	KOA SPEER ELECTRONICS INC	1	Minimum Number	1
5	AACBBBCC	KOA SPEER ELECTRONICS INC	4
6	AACBBBCC	KOA SPEER ELECTRONICS INC	5
7	AACBBBCC	KOA SPEER ELECTRONICS INC	6
8	AACBBBCC	KOA SPEER ELECTRONICS INC	3
9	AACBBBCC	KOA SPEER ELECTRONICS INC	2
10	AACBBBCC	KOA SPEER ELECTRONICS INC	1
11	AACBBBCC	KOA SPEER ELECTRONICS INC	4
12	AACBBBCC	KOA SPEER ELECTRONICS INC	5
13	AACBBBCC	MERITEK	6
14	AACBBBCC	MERITEK	3
15	AACBBBCC	MERITEK	2
16	AACBBBCC	NIC COMPONENTS CORP	1
17	AACBBBCC	NIC COMPONENTS CORP	4
18	AACBBBCC	RCD COMPONENTS INC	5
19	AACBBBCC	ROHM CORP	6
20	AACBBBCC	SEI ELECTRONICS	3
21	AACBBBCC	SEI ELECTRONICS	2
22	AACBBBCC	SEI ELECTRONICS	1
23
Contacts

Cell Formulas
Range	Formula
E3	E3	=SUM(--(FREQUENCY(IF(A2:A22=D2,MATCH(B2:B22,B2:B22,0)),ROW(B2:B22)-ROW(B2)+1)>0))
E4	E4	=MINIFS(C2:C22,A2:A22,D2)
Press CTRL+SHIFT+ENTER to enter array formulas.

Please don't forget to change your account details to show your version of Excel & then scroll down & click save.