Who is the biggest suuplier ?

[aviadht]

Hi,

Assume that i have table with the following columns:
1. Material number
2. Supplier name
3. Sum of mouney

For material 1002 i have 3 suppliers: A,B,C
The sum of mouney for A is 3000
The sum of mouney for B is 5000
The sum of mouney for C is 2500

I want a new table to contain each material number only one time in the first column, the biggest supplier in the second column.

What is the most efficient way to do it?

Thanks,
Aviad

 

[Yahya]

try this

Excel Workbook
	A	B	C	D	E	F	G	H
1	Material number	Supplier name	Sum of mouney			Material number	Supplier name	Sum of mouney
2	1002	A	3000			1002	B	5000
3	1002	B	5000			1003	C	6957
4	1002	C	2500			1004	B	6347
5	1003	A	2111
6	1003	B	4092
7	1003	C	6957
8	1004	A	1383
9	1004	B	6347
10	1004	C	4486
Sheet1

Excel 2010

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.


HTH