Hi, Need to Group the Id column and get the Min value from the date 1 and the Max value from the Date 2 . In the Amount 1 column need to get the parallel value of the Date 1 column In the Amount 2 column need to get the parallel value of the Date 2 column [image] Sample input file Input_Outpu…

Do you mean this ( From row In dtRead.AsEnumerable() Group row By k=row("Id").ToString.Trim Into grp=Group Let mindr = grp.OrderBy(Function(gr) gr("Date 1")).First() Let maxdr = grp.OrderByDescending(Function(gr) gr("Date 2")).First() Let d1 = mindr("Date 1") Let d2 = maxdr("Date 2") Let am…

Help on LINQ GroupBy, Max and Min

Help Activities

system (system) Closed October 13, 2022, 3:02pm 5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Sum of column based ondate column Activities excel , activities , question	6	1226	November 24, 2020
How to use group by and if activities together with linq? Studio activities , studio , question	2	779	November 13, 2022
GroupBy on 1 Column - calculate the Average and Sums of the group members Studio excel , activities , linq , assign	5	2557	November 25, 2021
Need LINQ expression Something Else feedback	16	668	June 1, 2023
Finding the total sum of 2 columns using LINQ Activities excel , activities , question	8	1767	July 18, 2022

Help on LINQ GroupBy, Max and Min

Related topics