Hi, I have to filter some excel rows based on on cell value like if the coloumn value,ID 1, i need to display all rows ID is not equal to 1
is there anything like this??
excelRange.AutoFilter(9, cellvalue !="1", Excel.XlAutoFilterOperator.xlFilterValues, Type.Missing, true);