View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
wahur wahur is offline
external usenet poster
 
Posts: 1
Default Counting single instances in a column


EN John
EN Jack
EN John
EN Anne
FR Peter
FR John

I want to get that I've got 3 translators for EN and 2 translators for
FR
It does not have to be one formula, e.g I can autofilter by language or
sort them by lang and copy by lang to other sheets. To use IT
terminology, I need to find out how many unique strings are in a
column.

Vahur


--
wahur
------------------------------------------------------------------------
wahur's Profile: http://www.excelforum.com/member.php...o&userid=26555
View this thread: http://www.excelforum.com/showthread...hreadid=559269