hi Team,
thank you in advance
i have this formula, however i am getting N/A, is there away amended this formula to ignore any N/A
=SUM(IF(FREQUENCY(IF(LEN(AN11:AN2993)>0,MATCH(AN11:AN2993,AN11:AN2993,0),""),IF(LEN(AN11:AN2993)>0,MATCH(AN11:AN2993,AN11:AN2993,0),""))>0,1))
Bookmarks