Login
Discover
Waves
Decks
Plus
Login
Signup
xlncad
@xlncad
46
Followers
12
Following
20
Resource Credits
Available
Used
Created
December 29, 2019
RSS Feed
Subscribe
Posts
Blog
Posts
Comments
Communities
Wallet
xlncad
Excel For All
2020-01-07 05:35
4 Methods to create a Unique list of records in Excel
4 different methods to create a Unique list of records in Excel are explained below. Pivot Table Array Formula Remove Duplicates Advanced Filter To create a unique list of records for each item (Product,
$ 0.223
10
7
xlncad
excel
2020-01-01 07:51
Apply AutoSUM for Multiple Row and Columns in Multiple worksheets in Excel
Following is my trick to apply AutoSUM for multiple Rows and Columns. *Select the entire data range with an Extra Column and Extra Row *Press ALT + = If you have multiple worksheets with similar data ranges,
$ 2.104
18
6
xlncad
Excel For All
2019-12-29 06:42
UnPivot or Reverse Pivot Data
I just found out that PivotTable and PivotChart Wizard can be used to ‘Unpivot’ or ‘Reverse Pivot’ in Excel. I will explain the procedure by UnPivotting the table shown below. PivotTable and PivotChart
$ 0.236
9
3
