Hey Guys,

I'm trying to exclude rows from one sheet but display all the other rows...example: Say the color red is in multiple rows and I want to exclude it and my sheets look like this below
A Column has Colors (A1),red(A2),blue(A3),green(A4)...etc in one sheet and in a new sheet I just want (A2 and A4) and the rest colors all except that red in the multiple rows. How do I go about doing that.

Thanks in advance.