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.
Could you please help.
Regards
Soumen
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