Count every time cell values change in a column?

**tavlrb** · 04-07-2011, 02:48 AM

Hi,

Please see the attached file - is there any way I can count the number of times the values in column B change one from part number to another?

Thank you for your help.

**batman07** · 04-07-2011, 03:11 AM

Hi tavlrb,

Just to clarify, your question is on how to count the unique values in column B?

Regards,
Batman

**tavlrb** · 04-07-2011, 03:22 AM

Sorry for the lack of clarity - what I'm looking for is a way to analyze each cell one-by-one starting with B1 all the way to B813 and count the number of times the values (part numbers) change. For example there are five "change overs" between B1 and B20.

**batman07** · 04-07-2011, 03:38 AM

Hope that I catch it right. See attachment for the solution.

I just used if and sum function.

**dadaenzo** · 02-04-2016, 06:21 AM

Hi Everyone,

can someone please advise how I can apply the below code to entire column Z and column AB?

Private Sub Worksheet_Change(ByVal Target As Range)

'// Changed cell is Z6?? Change to suit
'// Note now Z6 is tracked...
If Not Intersect(Target, Range("Z6")) Is Nothing Then
'// Increment tracker cell- Again, change to suit
Range("AB6").Value = Range("AB6").Value + 1
End If

End Sub

thanks