Tue 17 Jan 2017

## Solution - Challenge 58 - Make a Vedic Square

By |Tuesday, January 17th, 2017|Categories: Solutions||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||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

Sat 21 May 2016

## Article 39 - Sorting in Excel

By |Saturday, May 21st, 2016|Categories: Articles||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