Sat 20 Jan 2018

Challenge 69 - Need Help in Not Showing Comments

By |Saturday, January 20th, 2018|Categories: Challenges|Tags: , |1 Comment

Download the workbook. Whenever I select a cell, the yellow box pops up. I need your help to provide me instructions to remove these.

The workbook can be downloaded from Challenge 69 - Comments

The solution to above challenge will be published after a month i.e. on 20-Feb-2018.

Tue 16 Jan 2018

Solution - Challenge 67 - Generate a Particular Sequence

By |Tuesday, January 16th, 2018|Categories: Solutions|Tags: , , , , |0 Comments

Below is a possible solution to the problem Challenge 67 - Generate a Particular Sequence -

This consists of 2 logic.

  1. Generate Triangular number. The formula for which is n*(n+1)/2
  2. Generate Column Labels (A, B, AA, ZZ....) from numbers, the formula for which is

=SUBSTITUTE(ADDRESS(1,3,4),1,"") where 3 is for column C. So, we need to vary this 3.

The combined formula would be -


Sat 06 Jan 2018

Tips & Tricks 169 - Get the Source of a Pivot Table

By |Saturday, January 06th, 2018|Categories: Tips and Tricks, VBA|Tags: , , , , , , |0 Comments

1. Make a backup of your workbook.
2. Open your workbook and ALT+F11
3. Locate your Workbook name in Project Explorer Window
4. Right click on your workbook name > Insert > Module
5. Copy & Paste the below code in this module

Now, you can call this function like


Where E5 is any cell in your Pivot Table