# Posts by Djack92

• ## Average working days based on 2 criteria

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

• ## Average working days based on 2 criteria

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

• ## Average working days based on 2 criteria

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?

• ## Average working days based on 2 criteria

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

• ## Average working days based on 2 criteria

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.

• ## Count of each change made in a cell to another cell for entire column with exceptions

Hello royUK,

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

• ## Count of each change made in a cell to another cell for entire column with exceptions

Hello royUK,

I attached a sample of the file

Best Regards,

• ## Count of each change made in a cell to another cell for entire column with exceptions

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.

• ## Count of each change made in a cell to another cell for entire column with exceptions

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.

• ## Count of each change made in a cell to another cell for entire column with exceptions

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.

Code
``````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``````
• ## Count of each change made in a cell to another cell for entire column

Big thank you once again

• ## Count of each change made in a cell to another cell for entire column

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:

Code
``````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``````