Count but not Duplicates

[tclark14]

Is there a way to count a column of text, but count duplicates only once.

Thanks!

[duality]

=SUM(1/COUNTIF(Range,Range))

Subtitute your cell range (eg A1:A10) with "Range"

this must be entered as an array (Ctrl-shift-enter)

[duane]

assumed range is g7:g12

=COUNTA(G7:G12)-0.5*COUNTIF(G7:G12,G7:G12)

entered as an array (control+shift+enter)

[tclark14]

I finally got back to this and it workd great! Thanks for your help.