How to loop through cell to increment value on a different cell through VBA

[lgovindan]

Hi
I am trying to create a VBA script.

I have Customer Number on Column A, Date on Column B and Seq on Column C.

I start with Seq 1 for the first customer and date. If the next row has the same customer and the same date, I put seq 1 on column 1.
On change of any date for the same customer, increment seq by 1.
If the customer changes, reset seq to 1 and now loop through the on change of date increment the seq for that customer number
Repeat this until the end of the worksheet.

Visual
Customer - Date - Seq
10 Apr-4-2016 1
10 Apr-4-2016 1
10 Apr-5-2016 2
10 Apr-6-2016 3
10 Apr-6-2016 3
10 Apr-6-2016 3
10 Apr-6-2016 3
10 Apr-7-2016 4
15 Jan-1-2017 1
15 Feb-8-2017 2

So on and so forth.



I have 225000 records and am trying to automate this to get it done.

Can you please provide me a VBA script that will do this.

 

[jxb]

Just found time to actually try. The formula does not do exactly what you want. It kind of work but just realise that the sequence you are looking to establish is not what I understood the 1st time. So in simple term, forget about this approach

​

​

​