Thread: Counting unique values based on 2 columns
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default Counting unique values based on 2 columns
correction:

=COUNT(1/FREQUENCY(IF(F2:F100="Working",MATCH(D2:D100,D2:D1 00,0)),ROW(INDIRECT("1:"&ROWS(D2:D100)))))

--
isabelle

Le 2012-03-15 09:05, isabelle a écrit :
hi Tee51,


array formula to validate with ctrl + shift + enter

=COUNT(1/FREQUENCY(IF(D2:D100,MATCH(F2:F100,F2:F100,0)),ROW (INDIRECT("1:"&ROWS(F2:F100)))))

Reply With QuoteReply With Quote