Group by numbers and get a condition Max date

Lumjing

I want to get the below "Max date" say if I group by number 92 the the max date would be 3/3/2022. However if there is blank then max date will be blank as for the number 86. Can you please help to achieve this

numbers     Output dates          Max date
86               1/30/2022
86               1/30/2022
86
86               1/30/2022
92                2/3/2022               3/3/2022
92                1/3/2022
92                3/3/2022
92               4/2/2022

atcodedog05

Hi @Lumjing 

Here is how you can do it.

Workflow:

Hope this helps : )

max date.yxmd