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 · Accepted solution]

Hi @Lumjing 

Here is how you can do it.

Workflow:

Hope this helps : )

[gabrielvilella]

Please mention exactly what is your input data and the desired output. 

[Akash__on]

the dates are given in 

mm/dd/yyyy

format so how could 3/3/2022 (march 3 2022) be max date when we have 4/2/2022 (april 2 2022) present ?

I think it's a typo.

[Lumjing]

thank you for the help I was able to get the desired output

[atcodedog05]

Happy to help : ) @Lumjing 

Cheers and have a nice day!