above i keep the formula like
![]()
=SUM(IF(FREQUENCY(MATCH(B2:B11,B2:B11,0),MATCH(B2:B11,B2:B11,0))>0,1))
above i keep the formula like
![]()
=SUM(IF(FREQUENCY(MATCH(B2:B11,B2:B11,0),MATCH(B2:B11,B2:B11,0))>0,1))
Last edited by gsrikanth; 05-12-2014 at 04:53 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks