Averages by vendor

[Guest]

Hello,

I've got an excel table of over 20000 items, it includes demands, vendor codes and lead times.

Is there an easy way to compile a list of average lead times by vendor?

Pete

 

[Mark W.]

This can be easily accomplished with a PivotTable.

 

[Guest]

Thanks,

That was suprisingly easy & painless to do. I feel a bit stupid for asking now!

Pete