Tue 17 Jan 2017

Solution - Challenge 58 - Make a Vedic Square

By |Tuesday, January 17th, 2017|Categories: Solutions|Tags: , , , , , , |0 Comments

Below is a possible solution to Challenge 58 - Make a Vedic Square

Put the following formula in C3 and drag right and down

=MOD(C$2*$B3-1,9)+1

The Excel sheet having this solution can be downloaded from Solution - Challenge 58 - Make a Vedic Square

 

Sat 17 Dec 2016

Challenge 58 - Make a Vedic Square

By |Saturday, December 17th, 2016|Categories: Challenges|Tags: , , , , , , |1 Comment

Vedic square is below. In this, first row and first column are numbers 0 and 9. Other numbers are populated as per logic which you will need to identify.

More about Vedic Square at https://en.wikipedia.org/wiki/Vedic_square

1

(more…)

Sat 21 May 2016

Article 39 - Sorting in Excel

By |Saturday, May 21st, 2016|Categories: Articles|Tags: , , , , , , , , , , |0 Comments

First thing first – Excel doesn’t sort as per ASCII character codes which we generally expect. It has its own sorting logic which is detailed below for Ascending sort (reverse the same for Descending sort).

The order followed in an Ascending sort is Number > Text > Alphanumeric text > Logical values > Error values > Blanks

(more…)