count unique values in a column

**bqheng** · 07-04-2018, 12:48 AM

Hi, im trying out this code to populate total unique values from column A into textbox64 when commandbutton30 is clicked, but it gives me total count of everything instead. What should i change?

Please Login or Register  to view this content.

**MarvinP** · 07-04-2018, 01:07 AM

Hi bqheng,

Without having the workbook, it is hard to understand what is supposed to happen...

Perhaps your error is in:

Please Login or Register  to view this content.

and you might mean

Please Login or Register  to view this content.

This is just a wild guess!

**bqheng** · 07-04-2018, 02:03 AM

Here you go Marvin

**bqheng** · 07-04-2018, 02:24 AM

i solved it!! i was missing this line in the code

Please Login or Register  to view this content.

count unique values in a column

LinkBack

Thread Tools

Rate This Thread

Display

count unique values in a column

Re: count unique values in a column

Re: count unique values in a column

Re: count unique values in a column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to count unique distinct values from a column where values in other column exists ?

[SOLVED] Count number of unique values in Column A that match a term in Column B

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

Count Unique values in Column based on values in other columns

Count occurrences of unique values in a column in comparison with another column input

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

Count Unique Values In One Column Basis Unique Values in Another Column

Bookmarks

Bookmarks

Posting Permissions