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
|