## Solution - Challenge 68 - Generate a Particular Sequence

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

This consists of 2 logic.

- Generate Triangular number. The formula for which is n*(n+1)/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 -

=SUBSTITUTE(ADDRESS(1,(ROW(1:1)-1)*ROW(1:1)/2+1,4),1,"")

## Challenge 69 - Need Help in Not Showing Comments

By eforexcel|Saturday, January 20th, 2018|Categories: Challenges|Tags: Comments, SHIFT+F2|4 Comments

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 - CommentsThe solution to above challenge will be published after a month i.e. on 20-Feb-2018.