Hey all,

So, I'll make it snappy:

If I've got the following column:

Column A
A1 - Red
A2 - Blue
A3 - Invalid
A4 - Pink
A5 - Invalid
A6 - Orange

Is there an array which can translate that information into Column B as such:

Column B
A1 - Red
A2 - Blue
A3 - Pink
A4 - Orange
A5 - ""
A6 - ""

Essentially, getting rid of the specified variable ("Invalid" in this case) and pushing all the other variables to the top?

Previously, I was using this formula:

=IFERROR(INDEX('Raw Data'!G:G,SMALL(IF(ISNUMBER(SEARCH("??*",'Raw Data'!G$3:G$20)),ROW('Raw Data'!G$3:G$20)),ROWS($4:14))),"")

Where I had "1" rather than "Invalid" in Column A, but there are some unintended bugs that are making me want to change and use a variable rather than a number.

Any help is appreciated!