ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot table (https://www.excelbanter.com/excel-worksheet-functions/16931-pivot-table.html)

Gilles Desjardins

Pivot table
 
How does one create a pivot table with text columns in the data section.
I.e. I do not want sum, count, etc. I would like to see the text instead. I
don't think its possible, but I have been wrong many times before.

Thanks

Gilles



Dave Peterson

But I think you're correct this time. Pivottables are numeric summaries.

Gilles Desjardins wrote:

How does one create a pivot table with text columns in the data section.
I.e. I do not want sum, count, etc. I would like to see the text instead. I
don't think its possible, but I have been wrong many times before.

Thanks

Gilles


--

Dave Peterson


All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com