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...
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
Super User
Super UserHasn't Ahmedx already answered your question?