Thread: Counting unique values based on 2 columns
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vacuum Sealed Vacuum Sealed is offline
external usenet poster
  
Posts: 259
Default Counting unique values based on 2 columns
On 16/03/2012 12:09 AM, isabelle wrote:
correction:

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


Just to add to Isabelle's very nice work is you have to Array Enter the
formula with <CTRL-SHIFT-ENTER for it to work...

HTH
Mick.
Reply With QuoteReply With Quote