Uploading: earlist date.xlsx…
Hello Varun
i have tried it but i failed because my working file is with more column. and i am not sure about the formular of below:
(From row In inputDT
Group By id = row(0)
Into grp = Group
Let md = grp.Min(Function (d) d(1))
Select outDT.Rows.Add({id, CDate(md.ToString).ToString(“dd-MM-yyyy”)})).CopyToDataTable
what does “md” stands for? and also function(d) d(1)?
I have uploaded 1 new file with more column in sheet 1, and i expect result is in sheet2. if possible, pls help to check how to realize it.
earlist date.xlsx (12.6 KB)