Incremental counter for change across multiple columns
 

Hello

I have 40K rows and 3 columns that hold values. In column D, I would like a counter to show when there is any change in values in the first 3 columns.

Sample

ColA ColB ColC ColD

1 2 4 1
1 2 4 1
1 2 4 1
1 3 4 2
1 3 4 2
1 4 5 3
2 4 5 4
2 4 5 4

Please help if you can, I would appreciate it

Incremental counter for change across multiple columns
 

Am Fri, 25 Aug 2017 00:29:35 -0700 (PDT) schrieb :

I have 40K rows and 3 columns that hold values. In column D, I would like a counter to show when there is any change in values in the first 3 columns.

Sample

ColA ColB ColC ColD

1 2 4 1
1 2 4 1
1 2 4 1
1 3 4 2
1 3 4 2
1 4 5 3
2 4 5 4
2 4 5 4

if your numbers only have 1 digit you can enter a 1 in D1 and then in
D2:
=IF(A2&B2&C2<A1&B1&C1,D1+1,D1)
else try in D2:
=IF(A2&"*"&B2&"*"&C2<A1&"*"&B1&"*"&C1,D1+1,D1)
and copy the formula down.


Regards
Claus B.
--
Windows10
Office 2016