i have info many times duplicated and need to make a list of just.

[me]

Hi!!!!

I have a list of vendors and materials.
For each purchase an arrow.
So the vendor appears duplicated many times.
But I need to make a list of vendors and know wich product we buy to them.

do you know how to do it?

thanks
criognika

 

[Glenn]

Hi!!!!

I have a list of vendors and materials.
For each purchase an arrow.
So the vendor appears duplicated many times.
But I need to make a list of vendors and know wich product we buy to them.

do you know how to do it?

thanks
criognika

Try a PivotTable.

http://office.microsoft.com/en-us/excel/HA010346321033.aspx

 

[Ashish Mathur]

Hi,

Drag vendors and materials to the row area.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com