Tue 03 Jan 2017

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

By |Tuesday, January 03rd, 2017|Categories: Solutions||0 Comments

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

Use the below formula -

Mon 05 Dec 2016

## Solution - Challenge 55 - Make an Alphabetic Triangle

By |Monday, December 05th, 2016|Categories: Solutions||0 Comments

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

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

By |Saturday, December 03rd, 2016|Categories: Challenges||1 Comment

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

## Challenge 55 - Make an Alphabetic Triangle

By |Saturday, November 05th, 2016|Categories: Challenges||1 Comment

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

## Solution - Challenge 51 - Another Word Challenge - Whether Given Words are Anagram or not

By |Monday, October 10th, 2016|Categories: Solutions||0 Comments

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

## Solution - Challenge 49 – Whether a Word is Isogram or Not

By |Tuesday, September 13th, 2016|Categories: Solutions||0 Comments

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

## Challenge 51 - Another Word Challenge - Whether Given Words are Anagram or not

By |Saturday, September 10th, 2016|Categories: Challenges||1 Comment

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

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

## Solution - Challenge 48 - Whether a Sentence is Pangram or Not

By |Tuesday, August 30th, 2016|Categories: Solutions||0 Comments

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

## Challenge 49 - Whether a Word is Isogram or Not

By |Saturday, August 13th, 2016|Categories: Challenges||1 Comment

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

## Challenge 48 - Whether a Sentence is Pangram or Not

By |Saturday, July 30th, 2016|Categories: Challenges||1 Comment

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.