## Solution - Challenge 57 - Another Word Challenge - Palindrome or Not

Below is a possible solution to the **Challenge 57 - Another Word Challenge - Palindrome or Not**

Use the below formula -

Tue 03
Jan 2017

Below is a possible solution to the **Challenge 57 - Another Word Challenge - Palindrome or Not**

Use the below formula -

Mon 05
Dec 2016

Below is a possible solution to **Challenge 55 - Make an Alphabetic Triangle**

Put following formula AB4 somewhere and drag to the right.

Sat 03
Dec 2016

We earlier had challenges related to Pangram, Isogram and Anagram. This time, it is about Palindrome. A Palindrome is a word / sentence that reads the same from backward also as it reads from forward. Some of the famous Palindromes are

Sat 05
Nov 2016

This time challenge before you is to write a formula which can be dragged down, left and right to make the below triangle.

Mon 10
Oct 2016

Below is a possible solution to the **Challenge 51 - Another Word Challenge - Whether Given Words are Anagram or not**

Use following formula -

=IF(AND(LEN(A1)=LEN(B1),SUMPRODUCT(--(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),

UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),""))=LEN(B1)-LEN(SUBSTITUTE(

UPPER(B1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),""))))=LEN(A1)),"Anagram","Not Anagram")

Tue 13
Sep 2016

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")

Sat 10
Sep 2016

Given a word, an anagram is made by using all letters of the given word exactly once. For example, For example, my name "vijay" can be written as "jaivy", "yajvi" and so on....Some well known anagrams are

Lead - Flea

Admirer - Married

Listen - Silent

Mother in Law - Woman Hitler

Eleven Plus Two - Twelve Plus One

So, below is the challenge. Put original word in A1 and anagram in B1. You need to put a formula which gives the result "Anagram" if B1 has anagram of A1 and gives "Not Anagram" if B1 is not anagram of A1.

*The solution to the above challenge will be published after a month i.e. on 10-Oct-16.*

Tue 30
Aug 2016

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")

Sat 13
Aug 2016

This time, continuing my effort to make challenge on English language, the challenge is on Isogram. An Isogram is that word in English which doesn't repeat any alphabet. For example: "Botany" is an Isogram but "Britain" is not as "i" repeats.

Hence, this time, you need to make a formula which returns "Isogram" if the word is Isogram othewise returns "Not Isogram"

*The solution to above challenge will be published after a month i.e. on 13-Sep-16.*

Sat 30
Jul 2016

This time, I decided to pose a challenge on English words. A Pangram is that sentence in English which uses all 26 alphabets of English language at least once. A very common example is the very famous sentence "The quick brown fox jumps over the lazy dog" which contains all alphabets of English language at least once. Below link contains many other examples of Pangram.

http://www.rinkworks.com/words/pangrams.shtml

The challenge before you is to write a formula which gives the output "Pangram" or "Not Pangram" depending upon the fact if cell A1 has a Pangram sentence or not. Apart from English alphabets, the sentence can contain blanks, dots and commas and no other characters.

The given link contains many examples for Pangram which you can use as your test cases. Some examples from the above site -

A mad boxer shot a quick, gloved jab to the jaw of his dizzy opponent.

Big Fuji waves pitch enzymed kex liquor.

We quickly seized the black axle and just saved it from going past him.

*The solution to this challenge will be published after a month i.e. on 30-Aug-16.*