Sujeet Raman

Sujeet Raman

  • 862
  • 927
  • 354k

How to Autofilter Excel rows based on one cell value

Sep 7 2021 4:15 PM

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); 


Answers (4)