In the excel file i want to group all the same Serial No_ in one group and take the oldest Date in the output
Output should be like
I am attaching the data here
Cubage | Serial No_ | Posting | Date | |
---|---|---|---|---|
3 | SS-199796 | 21 January 2020 | abc | 22 January 2020 |
3 | SS-199796 | 21 January 2020 | abc | 27 January 2020 |
3 | SS-199796 | 21 January 2020 | abc | 23 January 2020 |
3 | SS-199796 | 21 January 2020 | abc | 01 February 2020 |
6 | UT-12345 | 15 February 2020 | xyz | 17 February 2020 |
6 | UT-12345 | 15 February 2020 | xyz | 10 February 2020 |
6 | UT-12345 | 15 February 2020 | xyz | 06 February 2020 |
Required Output data
Cubage | Serial No_ | Posting | Date | |
---|---|---|---|---|
3 | SS-199796 | 21 January 2020 | abc | 22 January 2020 |
6 | UT-12345 | 15 February 2020 | xyz | 06 February 2020 |
Please help
I am unable to find any solution for this problem