Hi All,
I have been using the following formula to count the number of unique text occurances in a list.
=SUM(IF(FREQUENCY(IF(LEN(H12:H37)>0,MATCH(H12:H37,H12:H37,0),""), IF(LEN(H12:H37)>0,MATCH(H12:H37,H12:H37,0),""))>0,1))
however i now want to do the same but for the range h12:u37
Is this possible with a siliar forumla, i have tried amending the above but it just returns N/A
Any help greatly appreciated.
Kind Regards
Alistair
I have been using the following formula to count the number of unique text occurances in a list.
=SUM(IF(FREQUENCY(IF(LEN(H12:H37)>0,MATCH(H12:H37,H12:H37,0),""), IF(LEN(H12:H37)>0,MATCH(H12:H37,H12:H37,0),""))>0,1))
however i now want to do the same but for the range h12:u37
Is this possible with a siliar forumla, i have tried amending the above but it just returns N/A
Any help greatly appreciated.
Kind Regards
Alistair