UNIQUE COUNTING IN A COLUMN

User avatar
PRADEEPB270
3StarLounger
Posts: 361
Joined: 27 Oct 2013, 15:11
Location: Gurgaon INDIA

UNIQUE COUNTING IN A COLUMN

Post by PRADEEPB270 »

Hi,

I am using excel 2019 version.

refer my attachment.

The query is how to determine or couning of thw unique word in a column.


Query is in column=B

Expected Result=E

Request please suggest appropriate an excel formula.
You do not have the required permissions to view the files attached to this post.
Regards

Pradeep Kumar Gupta
INDIA

User avatar
HansV
Administrator
Posts: 80088
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: UNIQUE COUNTING IN A COLUMN

Post by HansV »

Enter the following formula in E5 and confirm it by pressing Ctrl+Shift+Enter to turn it into an array formula:

=IFERROR(INDEX($B$5:$B$47, MATCH(0, COUNTIF(E$4:E4, $B$5:$B$47), 0)), "")

Fill down until the formula returns a blank. To count the unique values:

=COUNTIF(E5:E47, "> ")

If you only want to count the unique entries, without returning them in a range:

=SUMPRODUCT(1/COUNTIF(B5:B47, B5:B47))
Best wishes,
Hans

User avatar
PRADEEPB270
3StarLounger
Posts: 361
Joined: 27 Oct 2013, 15:11
Location: Gurgaon INDIA

Re: UNIQUE COUNTING IN A COLUMN

Post by PRADEEPB270 »

Thank you Hansv sir.
Regards

Pradeep Kumar Gupta
INDIA