Count unique values in column with duplicates

**rayted** · 06-06-2018, 03:47 AM

Hi guys

If I have a column (A2:A20) with the figures 1-20 with the number 2 appearing multiple times, how can I write a formula to count the number of 2's?

Thank you!

**kersplash** · 06-06-2018, 03:55 AM

Try this;

Formula:

Please Login or Register  to view this content.

**Phuocam** · 06-06-2018, 04:13 AM

Try this:

=MAX(FREQUENCY(A2:A20,ROW(1:20)))

**rayted** · 06-06-2018, 04:54 AM

thank you!

**rayted** · 06-06-2018, 04:58 AM

thanks v much!

Count unique values in column with duplicates

LinkBack

Thread Tools

Rate This Thread

Display

Count unique values in column with duplicates

Re: Count unique values in column with duplicates

Re: Count unique values in column with duplicates

Re: Count unique values in column with duplicates

Re: Count unique values in column with duplicates

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count Unique Values with Duplicates in Multiple Columns

Count unique values in one column based on conditions and unique values in another column

Count unique values (ignore duplicates) with multiple other column criteria

[SOLVED] Macro to count unique values in a column, enter it in next column, then delete duplicates

Count Unique Values In A Filtered Row with Duplicates

[SOLVED] Count unique values among duplicates in a subtotal range

Count number of unique items in a column that contains duplicates

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions