ExcelBanter - How to count the unrepeated objects on a excel list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to count the unrepeated objects on a excel list (https://www.excelbanter.com/excel-discussion-misc-queries/157565-how-count-unrepeated-objects-excel-list.html)

raul acosta

How to count the unrepeated objects on a excel list

Frequently I have to use a pivot table to count first column unrepeated
elements. Is there a function to do this?

Gary''s Student

How to count the unrepeated objects on a excel list

See:

http://www.cpearson.com/excel/Duplicates.aspx

scroll down to:

Counting Distinct Entries In A Range
--
Gary''s Student - gsnu200743

"raul acosta" wrote:

Frequently I have to use a pivot table to count first column unrepeated
elements. Is there a function to do this?

All times are GMT +1. The time now is 11:23 PM.