ExcelBanter - Counting Unique Alpahnumeric's in a list

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting Unique Alpahnumeric's in a list (https://www.excelbanter.com/excel-worksheet-functions/143126-counting-unique-alpahnumerics-list.html)

aspenelk

Counting Unique Alpahnumeric's in a list

I have huge column of alphanumeric data, some duplicated in different lines.
I need to be able to count or sum the unique entries?

Thanks, R. Rhoden

Teethless mama

Counting Unique Alpahnumeric's in a list

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

"aspenelk" wrote:

I have huge column of alphanumeric data, some duplicated in different lines.
I need to be able to count or sum the unique entries?

Thanks, R. Rhoden

All times are GMT +1. The time now is 04:21 AM.