Sequencing

[TheRins3r]

Hi,

Having trouble sequencing a block of numbers, ive a lot more to do, im currently manually doing it.

 

[DanteAmor]

This can be an option in B1 write the number 1 and in C1 the letter "A".
Put the formulas in B2 and C2 and copy them down

Dante Amor
	A	B	C
1	RF	1	A
2	RF	1	B
3	RF	1	C
4	RF	1	D
5	RF	2	A
6	RF	2	B
7	RF	2	C
8	RF	2	D
9	RF	3	A
10	RF	3	B
11	RF	3	C
12	RF	3	D
13	RF	4	A
14	RF	4	B
Hoja1

Cell Formulas
Range	Formula
B2:B14	B2	=IF(COUNTIF($B$1:B1,B1)=4,B1+1,B1)
C2:C14	C2	=IF(B1=B2,CHAR( CODE(C1)+1),"A")

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[TheRins3r]

=IF(B1=B2,CHAR( CODE(C1)+1),"A")

tHANKS A LOT, THAT WORKED

 

[Fluff]

@TheRins3r in future please mark the thread that contains the solution. Not your thread saying it works. Thanks

 

[TheRins3r]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

365, i updated my details to reflect