Help Please with calculating large data in Pivot Table
Closed
r71lima
Posts
3
Registration date
Saturday August 3, 2013
Status
Member
Last seen
August 4, 2013
-
Aug 4, 2013 at 01:01 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Aug 5, 2013 at 11:43 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Aug 5, 2013 at 11:43 AM
Related:
- Help Please with calculating large data in Pivot Table
- Transfer data from one excel worksheet to another automatically - Guide
- Digital data transmission - Guide
- Time table software free download full version - Download - Organisation and teamwork
- Excel data validation list from table multiple columns - Guide
- Html table size to fit window - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Aug 5, 2013 at 11:43 AM
Aug 5, 2013 at 11:43 AM
Hi R71lima,
Let me know what you think of the following:
Creating named ranges:
With your example A3:A16 is named MODELID (same as the header)
B3:B16 is named color and so on.
Cell J3: Is dropdown list to choose header (Model, color, etc....)
Cell J4: You type in the specification (i.e. for color choose RE/BK or GY/BK or ....)
Cell J7: Contains formula which shows result.
So basically choose category, choose what you want to count within the category and see the result.
The above is applied in the following file:
http://www.ge.tt/7nspf2o/v/0?c
Best regards,
Trowa
Let me know what you think of the following:
Creating named ranges:
With your example A3:A16 is named MODELID (same as the header)
B3:B16 is named color and so on.
Cell J3: Is dropdown list to choose header (Model, color, etc....)
Cell J4: You type in the specification (i.e. for color choose RE/BK or GY/BK or ....)
Cell J7: Contains formula which shows result.
So basically choose category, choose what you want to count within the category and see the result.
The above is applied in the following file:
http://www.ge.tt/7nspf2o/v/0?c
Best regards,
Trowa