Output for same ID which has blank and value in another column.

[akarca]

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

[Ahmedx]

pls try this

[Ashish_Mathur]

Hi,

Show the exact result you are expecting very clearly?  What does the ??? mean?

[akarca]

@Ashish_Mathur  could you help me please? 

[akarca]

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?