Forum Discussion
Output for same ID which has blank and value in another column.
Hello,
I have a question.
There are repeating numbers in the ID column. For each ID, there are dates and empty cells in column B. What I want to do is, if column B for an ID is empty and there is a date, write 1 in the status column. If all cells in column B are empty for repeating IDs, the status will remain empty.
| N | ID | A | B | status |
| 1 | 12345 | 1.01.2023 | 2.09.2023 | 1 |
| 2 | 3456 | 6.07.2023 | ||
| 3 | 12345 | 1.01.2023 | ??? | |
| 4 | 456234 | 9.05.2023 |
5 Replies
- Ahmedx
Super User
pls try this
Ashish_Mathur could you help me please?
Hello Mathur,
I have an excel table with employee IDs. The same ID repeats in the rows, but in some rows, there is an employment date and exit date for the same ID, but in some rows the exit date for this ID is empty. What I want to do: If there is an entry-exit date of the ID in one line and the exit date of the same ID is empty in the next lines, write the date on the filled line.
- Ashish_Mathur
Hasn't Ahmedx already answered your question?
- Ashish_Mathur
Hi,
Show the exact result you are expecting very clearly? What does the ??? mean?
