I have a datatable extracted from CRM. I have an excel. Three columns are ter in the excel. In data table I will have to make use of two columns and compare with one column of excel. In that excel column, half of the column has one data which is ter in column 1 of datatable. Half of the data is ter in column 2 of datatable. Using filter datatable, am able to either first half of the column or the second half…so any idea how to solve this?