View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LizG LizG is offline
external usenet poster
 
Posts: 2
Default count unique values in one column for a set value in another col.



"Jean-Luc" wrote:

I am trying to count how many unique values (text) I have in one column, for
the row cases where a particular value exists in another column.
Perhaps some combination of Frequency function with Countif or Sumproduct...?