I'm stumped on how to count the number of unique values in a column. This may be a problems solved many times before so please excuse a new forum member while I figure this out. What I have (simplified) is a table with invoice number in alpha numeric form like D47223, and another column with the dates that notices have been sent about each invoice. Each invoice number may appear more than once depending on how many notices have been sent about that invoice - one or several times. How can I count the number of times each unique invoice number appears without regard for number of corresponing notices? The table has hundreds to thousands of entries so building a table for a COUNTIF function is not feasible. Thanks in advance.
Bookmarks