View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sdsabo13@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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