Thread
:
Incremental counter for change across multiple columns
View Single Post
#
2
Posted to microsoft.public.excel.programming
Claus Busch
external usenet poster
Posts: 3,872
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch