Is it possible to pull the date from a cell, which is typically like this
I always want to pull the date from the "highest" row in the cell for Status change: In configuration
So, I would want to pull 07/01/2021 in this example.
Each line above is on a separate "row", but is in the same cell (for example N1)
Excel Formula:
07/01/2021 13:13:46 - Status change: Complete
07/01/2021 13:13:40 - Status change: In QA - BPS
07/01/2021 13:13:36 - Status change: In configuration
07/01/2021 13:13:33 - Status change: Governed
04/01/2021 10:23:52 - Status change: In configuration
04/01/2021 10:23:26 - Status change: Governed
04/01/2021 10:04:40 - Status change: Submitted
I always want to pull the date from the "highest" row in the cell for Status change: In configuration
So, I would want to pull 07/01/2021 in this example.
Each line above is on a separate "row", but is in the same cell (for example N1)