| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a List That is Pivotable
I have a worksheet of rows of customers and columns of products. There are about 250 customers and about 100 products. Therefore, there are 25,000 cells of data. Each cell contains the dollar amount of that product sold to that customer. I would like to create a 3-column list of data that contains customer-name, product-name and dollars sold. The number of rows in that list would equal the number of cells that are non-zero. In other words, cells with zero dollars can be ignored. How can this be accomplished?  -- Cecil ------------------------------------------------------------------------ Cecil's Profile: http://www.excelforum.com/member.php...o&userid=29035 View this thread: http://www.excelforum.com/showthread...hreadid=563906 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a list of items in a column? | Excel Worksheet Functions | |||
| Trying to Create a Conditional Drop down list | Excel Worksheet Functions | |||
| How to create a Sub validation list in excel? | Excel Discussion (Misc queries) | |||
| How do I create a command from a list box | Excel Discussion (Misc queries) | |||
| create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
