joshua1990
02-17-2018, 08:50 AM
Hey guys!
I am currently facing a somewhat more complex task and ask for your support :yes
I have data sets in the following structure:
These expand every week. The columns are always the same, but newer data appears for each name.
21636
I have a second table where I have the names 1 time each (1st column).
21637
In the third column, I write a date.
Now I have to somehow implement the following logic:
The goal is to get a "Go" or "Exit" in column "B" to the respective name.
If the selected date is less than the maximum of the record column "C", then write "Exit" in column "F". However, the maximum date only applies to the values with the status 1 (column "B").
However, only write "Exit" if the sum of the values for Status 1 (Data set - column "D") is greater than 20.
If the data is now expanding and the last date from the data set is greater than the one selected, "Exit" should continue to appear as long as the sum of state 1 is not greater than 30.
Then again from 30> Exit and rolling in 10 steps again.
Do you have an idea for that?
Is this possible without auxiliary columns?
Maybe its a new VBA function?
I am thankful for any advice!
Best regards
Josh
I am currently facing a somewhat more complex task and ask for your support :yes
I have data sets in the following structure:
These expand every week. The columns are always the same, but newer data appears for each name.
21636
I have a second table where I have the names 1 time each (1st column).
21637
In the third column, I write a date.
Now I have to somehow implement the following logic:
The goal is to get a "Go" or "Exit" in column "B" to the respective name.
If the selected date is less than the maximum of the record column "C", then write "Exit" in column "F". However, the maximum date only applies to the values with the status 1 (column "B").
However, only write "Exit" if the sum of the values for Status 1 (Data set - column "D") is greater than 20.
If the data is now expanding and the last date from the data set is greater than the one selected, "Exit" should continue to appear as long as the sum of state 1 is not greater than 30.
Then again from 30> Exit and rolling in 10 steps again.
Do you have an idea for that?
Is this possible without auxiliary columns?
Maybe its a new VBA function?
I am thankful for any advice!
Best regards
Josh