Excel Forum



YTLE#70 PivotTable & TRIM function & AVERAGES


See how to clean a bad data set with the TRIM function before building a Pivot Table (PivotTable) to calculate an Average.

Fix bad data with the TRIM function, then Pivot Table (PivotTable)





Got a Question? Ask it Here in the Forum.