Is there a way to count a column of text, but count duplicates only once.
Thanks!
Is there a way to count a column of text, but count duplicates only once.
Thanks!
=SUM(1/COUNTIF(Range,Range))
Subtitute your cell range (eg A1:A10) with "Range"
this must be entered as an array (Ctrl-shift-enter)
assumed range is g7:g12
=COUNTA(G7:G12)-0.5*COUNTIF(G7:G12,G7:G12)
entered as an array (control+shift+enter)
not a professional, just trying to assist.....
I finally got back to this and it workd great! Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks