Ignore any field which is not a Number and cannot be counted as Age in exce l.
how to filter this i only need age.
I also want the average of those players (Age<30) on the basis of Lowest and Highest Scores.
Let us take you are having a data table dta
Let dtb will be the filtered data.
dtb= (From p In dta.Select Where IsNumeric(p("Age").ToString) Select p).ToArray.CopyToDataTable
what is p?
You can filter the age by assigning
datatable =datatable.Select("Age < '30'").CopyToDataTable
Then Add a data column with column name “Average” and inside a for each activity for iterating datatable rows, assign
You can sort the average column by,
datatable.DefaultView.Sort = "Average ASC" and
Please check the demo workflow. Player-average.xaml (8.9 KB)
Player-avg.xlsx (8.3 KB)
p is Each Row of dataTable dta