Unique Manufacturers

soumen21

New Member
Joined
Aug 16, 2019
Messages
22
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 NumberMfr. NameNumber
AACBBBCCASJ PTE LTD3Total Number of unique manufacturers for AACBBBCC?
AACBBBCCCAL-CHIP ELECTRONICS INC2
AACBBBCCKOA SPEER ELECTRONICS INC1Minimum Number of AACBBBCC?
AACBBBCCKOA SPEER ELECTRONICS INC4
AACBBBCCKOA SPEER ELECTRONICS INC5
AACBBBCCKOA SPEER ELECTRONICS INC6
AACBBBCCKOA SPEER ELECTRONICS INC3
AACBBBCCKOA SPEER ELECTRONICS INC2
AACBBBCCKOA SPEER ELECTRONICS INC1
AACBBBCCKOA SPEER ELECTRONICS INC4
AACBBBCCKOA SPEER ELECTRONICS INC5
AACBBBCCMERITEK6
AACBBBCCMERITEK3
AACBBBCCMERITEK2
AACBBBCCNIC COMPONENTS CORP1
AACBBBCCNIC COMPONENTS CORP4
AACBBBCCRCD COMPONENTS INC5
AACBBBCCROHM CORP6
AACBBBCCSEI ELECTRONICS3
AACBBBCCSEI ELECTRONICS2
AACBBBCCSEI ELECTRONICS1

Could you please help.

Regards
Soumen
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
52,901
Office Version
  1. 365
Platform
  1. Windows
What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
52,901
Office Version
  1. 365
Platform
  1. Windows
Ok, how about
+Fluff New.xlsm
ABCDE
1Part NumberMfr. NameNumber
2AACBBBCCASJ PTE LTD3AACBBBCC
3AACBBBCCCAL-CHIP ELECTRONICS INC2Total Number of unique manufacturers8
4AACBBBCCKOA SPEER ELECTRONICS INC1Minimum Number1
5AACBBBCCKOA SPEER ELECTRONICS INC4
6AACBBBCCKOA SPEER ELECTRONICS INC5
7AACBBBCCKOA SPEER ELECTRONICS INC6
8AACBBBCCKOA SPEER ELECTRONICS INC3
9AACBBBCCKOA SPEER ELECTRONICS INC2
10AACBBBCCKOA SPEER ELECTRONICS INC1
11AACBBBCCKOA SPEER ELECTRONICS INC4
12AACBBBCCKOA SPEER ELECTRONICS INC5
13AACBBBCCMERITEK6
14AACBBBCCMERITEK3
15AACBBBCCMERITEK2
16AACBBBCCNIC COMPONENTS CORP1
17AACBBBCCNIC COMPONENTS CORP4
18AACBBBCCRCD COMPONENTS INC5
19AACBBBCCROHM CORP6
20AACBBBCCSEI ELECTRONICS3
21AACBBBCCSEI ELECTRONICS2
22AACBBBCCSEI ELECTRONICS1
23
Contacts
Cell Formulas
RangeFormula
E3E3=SUM(--(FREQUENCY(IF(A2:A22=D2,MATCH(B2:B22,B2:B22,0)),ROW(B2:B22)-ROW(B2)+1)>0))
E4E4=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. ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,481
Messages
5,596,396
Members
414,063
Latest member
N_Bates

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top