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

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

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

me wrote:
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/ex...346321033.aspx

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

Hi,

Drag vendors and materials to the row area.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"me" wrote in message
...
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