Hello Everyone.
I am working on one project and, among other things, I need certain results for further work. These results that I will use later are from columns (F, G and H). To get the data that I could process later, I used columns J and K to extract a number from columns D and E (using the function), then I used that number later under certain conditions.
The results I need to get are:
To get the results in column F (status 1) if the following condition is met:
- That the cells in column B contain the string "Weekly" and that the date from the cells in column C is less or equal than to the date in cell L2 (result "Yes")
- All other conditions (result "No")
To get the results in column G (status 2) if the following conditions are met:
- That the cells in column B contain the string "Daily", that the date from the cells in column C is greater or equal than to the date in cell L2 and that the number from the cells in column K is greater than the cells in column J (result "Yes")
- All other conditions (result "No")
To get the results in column H (status 3) if the following conditions are met:
- That the cells in column B contain the string "Weekly", that the date from the cells in column C is greater or equal than to the date in cell L2 and that the number from the cells in column K is greater than the cells in column J (result "Yes")
- All other conditions (result "No")
The code I made gives the necessary results, but somehow it seems to me that the code is too complicated (by my opinion). Is this the right way or maybe you have some other suggestion?
I am working on one project and, among other things, I need certain results for further work. These results that I will use later are from columns (F, G and H). To get the data that I could process later, I used columns J and K to extract a number from columns D and E (using the function), then I used that number later under certain conditions.
The results I need to get are:
To get the results in column F (status 1) if the following condition is met:
- That the cells in column B contain the string "Weekly" and that the date from the cells in column C is less or equal than to the date in cell L2 (result "Yes")
- All other conditions (result "No")
To get the results in column G (status 2) if the following conditions are met:
- That the cells in column B contain the string "Daily", that the date from the cells in column C is greater or equal than to the date in cell L2 and that the number from the cells in column K is greater than the cells in column J (result "Yes")
- All other conditions (result "No")
To get the results in column H (status 3) if the following conditions are met:
- That the cells in column B contain the string "Weekly", that the date from the cells in column C is greater or equal than to the date in cell L2 and that the number from the cells in column K is greater than the cells in column J (result "Yes")
- All other conditions (result "No")
The code I made gives the necessary results, but somehow it seems to me that the code is too complicated (by my opinion). Is this the right way or maybe you have some other suggestion?