Hi Frnds ,
Please help me with the formula to extract the latest date per id .
I am attaching below the input i am having and the required output for this.
eg- Input
ID date 1 date 2
1 13/02/2018
2 13/02/2018 12/02/2018
2 14/02/2018
3 13/02/2018 13/02/2018
3 14/02/2018 13/02/2018
3 15/02/2018 18/02/2018
3 13/02/2018 13/02/2018
output
ID date 1
1 13/02/2018
2 14/02/2018
3 18/02/2018
please help me with this.
thanks in advance
Solved! Go to Solution.
Hi @Ekta,
You will first need a Transpose tool with ID as Key Fields and date1 and date2 as Data Fields. Then you will need a Summarize tool with ID as GroupBy and Value as Max.
Thanks,
Jasper
Thank you so much, worked perfectly fine :)