xlncad (46)in Excel For All • 5 years ago4 Methods to create a Unique list of records in Excel4 different methods to create a Unique list of records in Excel are explained below. Pivot Table Array…xlncad (46)in #excel • 5 years agoApply AutoSUM for Multiple Row and Columns in Multiple worksheets in ExcelFollowing is my trick to apply AutoSUM for multiple Rows and Columns. *Select the entire data range with an Extra…xlncad (46)in Excel For All • 5 years agoUnPivot or Reverse Pivot DataI just found out that PivotTable and PivotChart Wizard can be used to ‘Unpivot’ or ‘Reverse Pivot’ in Excel. I will…