Filtering Rows
Hi,
I have a spreadsheet in which I am trying to Filter Out Contractors. Basically the Column can have several values. It can either be blank, PRE or have another value which can vary. I want to be able to filter rows which are neither Blank or Pre. The Values are in column H. I created a helper column in column I with the following formula =H2="". I then created another helper column in column J with the formula =H2<>"PRE". Both formulas work OK. My question is how do I combine the two formulas so that I end up with the rows which do not contain Blank or Pre. I tried =H4="" or H4="PRE" but I get a message saying that my formula contains an error.
Thanks
|