Three-way pivot table
ClementH3o
Posted messages
9
Status
Membre
-
ClementH3o Posted messages 9 Status Membre -
ClementH3o Posted messages 9 Status Membre -
Hello,
I would like to generate a table summarizing certain information based on data lists that I have. The lists contain different types of media, page numbers, and page types, all grouped by lot.
Data:
I would like to generate a table that indicates the pages where a page type can be found based on the media AND the lot. It would look something like this (in the idea):
It seems that I need to use a pivot table, but I haven't managed to do it so far. I have tried several arrangements of the base lists (in column, in row) as I believe that’s where the problem lies, but I’m not sure. If there is another way to do this (aside from pivot tables), I’m open to suggestions!
I can't currently upload a sample file (connection blocked), but I will do it as soon as tonight if needed.
Thank you in advance!
Clément
Configuration: Windows 7 / Internet Explorer 9.0
I would like to generate a table summarizing certain information based on data lists that I have. The lists contain different types of media, page numbers, and page types, all grouped by lot.
Data:
I would like to generate a table that indicates the pages where a page type can be found based on the media AND the lot. It would look something like this (in the idea):
It seems that I need to use a pivot table, but I haven't managed to do it so far. I have tried several arrangements of the base lists (in column, in row) as I believe that’s where the problem lies, but I’m not sure. If there is another way to do this (aside from pivot tables), I’m open to suggestions!
I can't currently upload a sample file (connection blocked), but I will do it as soon as tonight if needed.
Thank you in advance!
Clément
Configuration: Windows 7 / Internet Explorer 9.0
3 réponses
Hello,
In your case, the Pivot Table is a poor choice. The Pivot Table allows you to sum, count, display the max, min value, etc., but it won't list multiple data points related to the same criterion.
The only possible solution, in my opinion, is VBA.
To my knowledge, no Excel function can achieve your result.
In your case, the Pivot Table is a poor choice. The Pivot Table allows you to sum, count, display the max, min value, etc., but it won't list multiple data points related to the same criterion.
The only possible solution, in my opinion, is VBA.
To my knowledge, no Excel function can achieve your result.
