generate the 7 3-letter formations a b c possible .

piter

Active Member
Joined
Jul 22, 2011
Messages
309
Office Version
  1. 2016
Platform
  1. Windows
generate the 7 3-letter formations
a b c possible
example = aaaaaaa, aaaaaab .... ccccccc
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,770
Office Version
  1. 2010
Platform
  1. Windows
A​
B​
C​
D​
E​
F​
G​
H​
1​
a​
a​
a​
a​
a​
a​
a​
A1: =CHAR(97 + MOD(INT(3 * (ROWS($G$1:A1) - 1) / 3 ^ COLUMNS($G$1:A1)), 3))
2​
a​
a​
a​
a​
a​
a​
b​
3​
a​
a​
a​
a​
a​
a​
c​
4​
a​
a​
a​
a​
a​
b​
a​
5​
a​
a​
a​
a​
a​
b​
b​
2182​
c​
c​
c​
c​
c​
b​
a​
2183​
c​
c​
c​
c​
c​
b​
b​
2184​
c​
c​
c​
c​
c​
b​
c​
2185​
c​
c​
c​
c​
c​
c​
a​
2186​
c​
c​
c​
c​
c​
c​
b​
2187​
c​
c​
c​
c​
c​
c​
c​
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,157
Messages
5,527,131
Members
409,749
Latest member
esmarques

This Week's Hot Topics

Top