Is this a use for a PIVOT Table?/
You can use the pivot table for doing what you want - you might just need to add a column so you can identify "Ordered" by a unique identifier - i.e. Date, or "Ordered" - YES or NO, etc. The nice thing about pivot tables it takes NO extra work on your part once you have the basic information. It is just a matter of using the columns you alread have and then deciding how to place them in the PIVOT Table. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=501710 |
All times are GMT +1. The time now is 01:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com