ExcelBanter - PIVOT TABLE FIELD

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - PIVOT TABLE FIELD (https://www.excelbanter.com/excel-discussion-misc-queries/251195-pivot-table-field.html)

PIVOT TABLE FIELD

I have in my columns (data) more than 100 columns; they are set as SUM. How
can I change them in MAX or COUNT as a bulk instead of going seperately on
each column and changing the sum into max?

All times are GMT +1. The time now is 07:00 PM.