Count the Number of Unique Values in a List

2 views

Skip to first unread message

unread,

Feb 2, 2016, 9:45:42 AM2/2/16

to Excel VBA Lab

Dear All,

How can we count the number of unique value in a list. ?

Example : Data in Column A

State Name

Delhi

Rajasthan

Gujarat

Mumbai

Madhya Pradesh

Haryana

Delhi

Rajasthan

Bengal

Delhi

Output Required : 7

Thanks

Vibhuti

unread,

Feb 2, 2016, 10:22:25 AM2/2/16

to Excel...@googlegroups.com

Hi,

Check this.

Note : Please visit on group page for download the sheet.

Regards

Ashish Kumar

Count Unique.xlsx

Reply all

Reply to author

Forward

0 new messages