Sat 30 Sep 2017

Tips & Tricks 163 - Convert Alphabets to Numbers

By |Saturday, September 30th, 2017|Categories: Tips and Tricks|Tags: , , , , , , |0 Comments

If you want to convert a, b, c....z to 1, 2,3....26, the you can use following type of formula -

=CODE(UPPER(A1))-64

Tue 03 Jan 2017

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

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

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

Use the below formula -

(more…)

Mon 05 Dec 2016

Solution - Challenge 55 - Make an Alphabetic Triangle

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

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

Put following formula AB4 somewhere and drag to the right.

(more…)

Sat 03 Dec 2016

Challenge 57 - Another Word Challenge - Palindrome or Not

By |Saturday, December 03rd, 2016|Categories: Challenges|Tags: , , , , , , , , , , |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

(more…)

Sat 05 Nov 2016

Challenge 55 - Make an Alphabetic Triangle

By |Saturday, November 05th, 2016|Categories: Challenges|Tags: , , , , |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.

(more…)

Mon 10 Oct 2016

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

By |Monday, October 10th, 2016|Categories: Solutions|Tags: , , , , , , , , , |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|Tags: , , , , , , , , , |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|Tags: , , , , , , , , , |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

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

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

By |Tuesday, August 30th, 2016|Categories: Solutions|Tags: , , , , , , , |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|Tags: , , , , , , , , , |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.