Below is a possible solution to the challenge – Challenge 48 – Whether a Sentence is Pangram or Not
=IF(ISNUMBER(SUMPRODUCT(MATCH(ROW($65:$90),INDEX(CODE(MID(SUBSTITUTE(SUBSTITUTE(
SUBSTITUTE(UPPER(A1)," ",""),".",""),",",""),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(SUBSTITUTE(
SUBSTITUTE(A1," ",""),".",""),",","")))),1)),,),0))),"Pangram","Not Pangram")
Update on 10-Aug-21: The above can be done with a simpler formula
=IF(ISNUMBER(MATCH(FALSE,ISNUMBER(SEARCH(CHAR(ROW(97:122)),A2)),0)),
"Not Pangram","Pangram")
You will have to confirm the above formula with CTRL+SHIFT+ENTER i.e. as an array formula if you are not using Office 365.