Count unique records

Good Afternoon,

Have an excel sheet with over 330k lines of data.  Would like to count unique records in one of the columns but not sure what the formula is to do so.  I have used the advanced filter/unique records but it locks up and Excel is Not Responding.  I assume it is because of the number of lines.
Nick
nmolliconiAsked:
Who is Participating?
 
cyberkiwiConnect With a Mentor Commented:
For a one off, you could create a pivot table over just that column, and drag the column into the Row section (left part) and scroll to the bottom to check the count.  (if it starts at row 9 and ends at row 19, that's 11 unique values for that column)
0
 
nmolliconiAuthor Commented:
Great suggestion!  Thank you.

Nick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.