Excel age filteration

Help
1

Hey all
Ignore any field which is not a Number and cannot be counted as Age in exceScreenshot%20(17) l.
how to filter this i only need age.
thanks

2

I also want the average of those players (Age<30) on the basis of Lowest and Highest Scores.

3

@Shobhit_sachan

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

Regards,
Mahesh

1 Like
4

what is p?

5

Hi Shobit,

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 row("Average")= (cint(row("Low"))+cint(row("High")))/2
You can sort the average column by,
assign datatable.DefaultView.Sort = "Average ASC" and
datatable=datatable.DefaultView.ToTable

Please check the demo workflow. Player-average.xaml (8.9 KB)
Player-avg.xlsx (8.3 KB)

Warm regards,
Nimin

6

@Shobhit_sachan
p is Each Row of dataTable dta

Regards,
Mahesh

7

thanks
@nimin

1 Like