i am trying to get a formula that will count the number of occurrences in which a unique value appears on one excel table column if there is a value (any) on the same row for that unique value on another column. the formula i am using is:
=SUM(IF(FREQUENCY(MATCH([User Name/ Member ID],[User Name/ Member ID],0),MATCH([User Name/ Member ID],[User Name/ Member ID],0))>0,1))
Bookmarks