Averages by vendor

Mar 5th, 2002, 08:24 AM

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. · Mar 5th, 2002, 08:25 AM

This can be easily accomplished with a PivotTable.

Mar 5th, 2002, 08:35 AM

Thanks,

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

Pete

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 08:24 AM	#1
Guest Posts: n/a	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

Mar 5th, 2002, 08:25 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	This can be easily accomplished with a PivotTable.

Mar 5th, 2002, 08:35 AM	#3
Guest Posts: n/a	Thanks, That was suprisingly easy & painless to do. I feel a bit stupid for asking now! Pete