Get Min and Max Value from datatable

Welcome to the forum

we can achieve this grouping the data by the empid:

Option 1: filtering on distinct empids and processing the group members

after filtering we can get the:

minVal = dtFiltered.AsEnumerable.Min(Function (x) CDbl(x("oursAllocated").toString.Trim))
maxVal=  dtFiltered.AsEnumerable.Max(Function (y) CDbl(y("Employee ID - COOIS").toString.Trim))

option: LINQ statement

prepare target datatable with build datatable, configure 3 cols: empid, min, max - dtResult

use an assign activity:
LHS: dtResult

(From d in YourDataTableVar.AsEnumerable
Group d by k=d("empid").toString.Trim into grp=Group
Let hro = grp.Min(Function (x) CDbl(x("HoursAllocated").toString.Trim))
Let coo= grp.Max(Function (y) CDbl(y("Employee ID - COOIS").toString.Trim)) 
Let ra = new Object(){k, hro, coo}
Select r=dtResult.Rows.Add(ra)).CopyToDataTable

also have a look here: