Below is a possible solution to the challenge – Challenge 49 – Whether a Word is Isogram or Not
Use following formula –
=IF(SUMPRODUCT(–(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW($65:$90)),""))>1))
=1,"Not Isogram","Isogram")
Below is a possible solution to the challenge – Challenge 49 – Whether a Word is Isogram or Not
Use following formula –
=IF(SUMPRODUCT(–(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW($65:$90)),""))>1))
=1,"Not Isogram","Isogram")