Jun 25 2021 07:06 AM
Hello all,
I hope I am able to explain what I want to do properly, so here it goes:
I have two cells that I want to count the values of, but the second cell is constantly being updated with a new value (a date). I want to count in a third cell the value on the first cell plus the number of times a new value was put in the second cell. So for example, there is a date in the first cell, the second cell had a date as well one day, two days later another date is put in that cell, the third cell should have a final count of 3 (instead of 2 which would happen if I used the COUNT formula).
I honestly don't know if this is possible but if it isn't any advice would be appreciated.
Thank you!
Jun 25 2021 08:21 AM
Could you please provide small sample file to illustrate the question?
Jun 25 2021 08:27 AM
Jun 25 2021 08:34 AM
I see, thank you. That's with VBA programming. Sorry, not my territory, perhaps someone else could help.
Jun 25 2021 10:48 AM - edited Jun 25 2021 10:49 AM
SolutionHello @DianaRato,
Enter this VBA code as a procedure in the necessary worksheet:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Sheets("Sheet1").Range("A1"), Target) Is Nothing Then
Range("B1").Value = Range("B1").Value + 1
End If
End Sub
Where...
Jun 25 2021 10:48 AM - edited Jun 25 2021 10:49 AM
SolutionHello @DianaRato,
Enter this VBA code as a procedure in the necessary worksheet:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Sheets("Sheet1").Range("A1"), Target) Is Nothing Then
Range("B1").Value = Range("B1").Value + 1
End If
End Sub
Where...