You can try this formula.Entered with ctrl+Shift+EnterFormula:
=COUNT(1/FREQUENCY(IF(B9:B182&C9:C182<>"",MATCH(B9:B182&C9:C182,B9:B182&C9:C182,0)),ROW(B9:B182)-ROW(B9)+1))
You can try this formula.Entered with ctrl+Shift+EnterFormula:
=COUNT(1/FREQUENCY(IF(B9:B182&C9:C182<>"",MATCH(B9:B182&C9:C182,B9:B182&C9:C182,0)),ROW(B9:B182)-ROW(B9)+1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks