(Excel 2007) I have a report with 10 columns. Out of those 10, I have 3 columns that I am using a filtering macro on. If the cell in column A is >325 AND on that same row column B is >325 AND same row on column C is >150, then we keep that whole row in the report.
Otherwise, it hides the whole row if even one of those columns don't match the criteria.
My question: My boss now wants me to show the row if column A is >325 OR column B is >325 (also, column C will still have to be >150. Is there a way to do this with filtering? Kind of an <or> command, or do I need some sort of vba code? Is this even possible?
Bookmarks