# 1 2 sequence

#### andrichara

##### New Member
hi to all, i have in G:G a constant values of 1 and 2 and does not change ,is fixed.at F:F there are random variable values of 1 and 2 .what i need is a formula at E1 which counts if for example like workbook attached:if F1 =G1 count 0,if F2=G2 count 0,F3=G3 count 0, F4<>G4 count 1, if F5<>G5 count2,if F6<>G6 count 3 ..and so on ,at F7=G& count zero.I hope i explain well.thanks so much!!

### Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

#### andrichara

##### New Member
at F:F is changing values of 1 and 2 that comes from a random generator,so always look the last value and if is equal with the opposite G:G cell, which is fixed count 1 if is equal count zero

#### andrichara

##### New Member
F G G values are fixed
1
2
1
2
1
2
1
2
1
2
1
2
1
2
1
2
1
.
.

#### andrichara

##### New Member
sorry what i wrote before are the G fix values

#### jtakw

##### Well-known Member

Hi,

If you can have a Blank or Header row use I2 formula copied down, otherwise use E1 formula copied down:

#### andrichara

##### New Member
super! thanks so mucjh

You're welcome.

Replies
2
Views
53
Replies
3
Views
54
Replies
6
Views
102
Replies
3
Views
329
Replies
1
Views
80

1,109,431
Messages
5,528,735
Members
409,831
Latest member
KT50

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...