unique records

Pyotr · Nov 4, 2004

Is there a formula to determine the number of unique items in a columm?

Domenic · Nov 4, 2004

=SUM(IF(A1:A10<>"",1/COUNTIF(A1:A10,A1:A10)))

...entered using CONTROL+SHIFT+ENTER.

Hope this helps

Delete 100 Hundred Unique Values From Word Document	0	Sep 7, 2021
Autonumber field in Excel that behaves the same as Access	0	Jun 16, 2022
Fill cells based on the other 3 cells unique combination the value on the target cell	0	Apr 10, 2018
Counting unique instances of a text string	2	Feb 15, 2013
Count Number of Unique Cells That Don't Have Certain Characters	0	Jan 21, 2014
Unique Records in Column	3	Mar 17, 2012
Unique records of matching pairs	0	Oct 25, 2005
How do I formulate total before Gst?	2	Nov 12, 2009

Ask a Question