THIS SITE HAS BEEN ARCHIVED AND CLOSED.

Please join the conversation over on our new forums »

If you really want to read this, try using The Internet Archive.

Jordan_229_2 [Edit] [Delete] 09:55, 8 March '13

=SUM(IF(FREQUENCY(MATCH(Data!M2:M20,Data!M2:M20,0),MATCH(Data!M2:M20,Data!M2:M20,0))>0,1))