ExcelBanter - How can I count unique strings of data in a field?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I count unique strings of data in a field? (https://www.excelbanter.com/excel-discussion-misc-queries/218161-how-can-i-count-unique-strings-data-field.html)

ManhattanRebel

How can I count unique strings of data in a field?

I want to count unique strings of data in a column. Is there a easy way to do
this?

muddan madhu

How can I count unique strings of data in a field?

try this

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

On Jan 28, 6:24*pm, ManhattanRebel
wrote:
I want to count unique strings of data in a column. Is there a easy way to do
this?

ManhattanRebel

How can I count unique strings of data in a field?

Thank you that is exactly what I needed.

"muddan madhu" wrote:

try this

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

On Jan 28, 6:24 pm, ManhattanRebel
wrote:
I want to count unique strings of data in a column. Is there a easy way to do
this?

All times are GMT +1. The time now is 07:20 AM.