Posts by Djack92

Hi sorry for late reply,

yeah maybe will have to think of another way to get it, but thank you for the help and guide

in the file, you added a new column of Work Days.

in my source, I can not add such a column.
that is why I said that I can not manipulate and add this column and use it with the formula you specified in the file

Yeah something like that just 1 stuff I can not add another row
is there a possibility to integrate =NETWORKDAYS(A8; B8) into the formula?

Hello royUk,

Let's split it into 2 parts:

1)
I need to find out the average number of days that have been worked in each location.
For example, different people worked in London, the start date and end date are different, so I want to know on average how many days people have worked in London.

2) also to split them by age.
As an example, we have 2 people of age 25 that have worked in London with different end and start dates so I want to count the average worked days for both of them.

I am not sure that I explained it clearly but thank you once again in advance for trying to help

Hello,

I got stuck and you guys are my last hope

I have a list of employees with start and end dates, locations, and ages.
Wanted to create a table that will show me the average working days (end date - start date) based on criteria of age and location.

And I can not crack it out I started with Averageif but besides that, I am out of ideas.

I attached a file for easier understanding.

Thank you in advance for all the suggestions.

Hello royUK,

Sorry for the late reply, the code is working
Thank you a lot for the help.

Hello royUK,

Sorry for the late reply.

I attached a sample of the file

Best Regards,

Hi royUK,

I tried to run it but I got compile error: Sub or Function not defined.
tried to figure out the issue and can not see the problem.

Hello royUk,

Yes, the cell has Data Validation List (in the list I have NO, YES, MAYBE, and another 4 options ).

So basically i want to remove these 3 options from counting and to be able to count only the other 4 options.

Hello,

With the help of the people from this forum, we arrived at the bellow code, now I faced a different challenge I would like the code to log the change of the cell, like is doing with the bellow code just in case of a specific change (example in column 4 I choose from drop-down list NO, YES, MAYBE ) the VBA should not count them as a change, but any other value should be counted towards the changes counter.

Any idea or hint will be welcomed.
P.S Big thx to the people that helped me last time.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Target.Column = 4 Or Target.CountLarge > 1 Then Exit Sub
Application.EnableEvents = False
Target.Offset(, 1).Value = Target.Offset(, 1).Value + 1
Application.EnableEvents = True
End Sub

Big thank you once again

Big thank you  royUK and rory both codes worked perfectly thank you so much,

RoyUk I will check the rules next time thank you once again

Hello,

I need a function that records the number of times a cell in a worksheet has a value change.
I got it, how to count for 1 cell but my brain just can not crack how to make it work for the entire column.
So as an example :
I have a value in D8 and need to record it in E8
and so on for the entire column D9 to E9
I'm really new to all this code stuff so help would be very much appreciated.

P.S only my solution, for now, is to do it for each cell in particular like this:

If Not Intersect(Target, Range("D8")) Is Nothing Then
Range("E8").Value = Range("E8").Value + 1
End If
If Not Intersect(Target, Range("D9")) Is Nothing Then
Range("E9").Value = Range("E9").Value + 1
End If