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.
UNIQUE COUNTING IN A COLUMN
-
- 3StarLounger
- Posts: 361
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
UNIQUE COUNTING IN A COLUMN
You do not have the required permissions to view the files attached to this post.
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA
-
- Administrator
- Posts: 80088
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: UNIQUE COUNTING IN A COLUMN
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))
=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
Hans
-
- 3StarLounger
- Posts: 361
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA