Sorting dates.xlsx (10.7 KB)
Hi all,
I need to sort the dates based on the customer ID. The dates are present in different application columns in excel. I need to pick any two oldest dates for that particular row.
This above picture in the input file. I want the output file to look like the picture below.
So along with the two oldest dates, I need to pick the column name also.
please help. I need to complete this urgently.