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
Solved! Go to Solution.
Please mention exactly what is your input data and the desired output.
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.
thank you for the help I was able to get the desired output
Happy to help : ) @Lumjing
Cheers and have a nice day!
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |