Excel VBA - loop through 2 columns on change

[ronanmeyler1]

I have an Excel sheet with 3 columns. The EmployeeID is in column A and this is repeated for whatever number or records it has. In column B there is a start date, and in column C a Talent change.
I want to output in column D, a result which shows the Talent when it changes.
And in Column E, the number of days it took them to get that Talent.

I have simplified the sheet, so my attempt didn't quite work. It did give me start and end talent and one of the dates...

Any insight would be so so appreciated. I have attached the sample...

Regards

Ronan

 

[kjv1611]

I must be missing something, but couldn't you handle this with a few formulas, rather than needing code? Formulas automatically update as the data they reference changes.

 

[ronanmeyler1]

Thanks, but can't think of how to have the formula catch a count on each change of ID...

Ronan

 

[SkipVought]

Something like...
[tt]
=IF(A2&B2=A1&B1,"no change","change")
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ronanmeyler1]

Thank you for the reply...

I appreciate the simlistic thinking, something I forget about in my process.
I will do various instances of those based on my different columns and needs and then Pivot it all up later.
I must learn, that clever isn't always better.

Regards

Ronan