LISTDISTINCTS Examples

Sample Data

LISTDISTINCTS Array-entered 6 rows, 2 columns, ByRows

Each distinct row in the input is shown. The extra 2 rows are padded with #N/A.

LISTDISTINCTS.COUNT Array entered 6 rows, 3 cols, ByRows, filled with blanks

Each distinct row in the input is shown with a count of the number of occurrences. The extra 2 rows are padded with blanks.

LISTDISTINCTS.COUNT Array entered 6 rows, 3 cols, ByRows=False, filled with blanks

Each distinct item in the Input Data is listed with a count of the number of ocurrences, the extra 2 rows and column are filled with blanks.

LISTDISTINCTS.SUM Array entered 6 rows, 3 cols filled with blanks

The distinct rows are listed with the sum of column E (Spend)

LISTDISTINCTS.AVG Array entered 6 rows, 3 cols filled with blanks

The distinct rows are listed with the average of their Column E Spend.

COUNTDISTINCT ByRows. Single cell formula, NOT array-entered

There are 4 distinct rows in A2:B7

COUNTDUPES ByRows. Single cell formula, not array entered

There are only 2 duplicates in A2:B7 (2 Rows appear twice)

COUNTDISTINCT ByRows=False

There are 6 distinct items in A2:C7

LISTDISTINCT ByRows=False

The 6 distinct items in A2:C7 are listed

COUNTDUPES ByRows=False

There are 12 duplicated items in A2:C7

(3 x Direct, 1 x Retail, 2 x Defense, 2 x Mfg, 1x SpaceCalls, 3 x SuperPhone)