Forum Discussion
Solved
finding the max date per unique id and return value in certain column
Hello, Hope someone can help I have the below. I want to find the latest date per each unique ID and return the corresponding status. In this case A = inbound B = complete ID Date...
Dates of december are of 2020. I forgot to change the format of column B sorry. Please compare attached file.
in your example shouldnt it return
Largest date for A is 12/31 therefore corresponding status is Sale
Largest date for B is 12/30therefore corresponding status is Purchase
Largest date for A is 12/31 therefore corresponding status is Sale
Largest date for B is 12/30therefore corresponding status is Purchase
Dates of december are of 2020. I forgot to change the format of column B sorry. Please compare attached file.
- Awesome! Danke schön