Unique Counts and Listing of Uniques

Date 16 August 2017
Author exceldepo
Category Power Query
Type XLSX

An Excel file that teaches how to perform Unique Counts and Listing of Uniques operation.

Excel-Based Unique Counts and Listing of Uniques

Non-repetitive records are removed from the source list with array formulas. The number of times each value occurs is shown in a separate column. The results are made suitable for summary reporting.

Hope it is useful.

ADVERTISEMENT AREA

Related Files