G Guest Sep 8, 2007 #1 Frequently I have to use a pivot table to count first column unrepeated elements. Is there a function to do this?
Frequently I have to use a pivot table to count first column unrepeated elements. Is there a function to do this?
G Guest Sep 8, 2007 #2 See: http://www.cpearson.com/excel/Duplicates.aspx scroll down to: Counting Distinct Entries In A Range
See: http://www.cpearson.com/excel/Duplicates.aspx scroll down to: Counting Distinct Entries In A Range
