FILTERING
 

DISPLAYING ALL THE ROWS WHERE THE COLUMN VALUE IS EQUAL TO 1 OR 2 OR 2 OR 4

FILTERING
 

This is not a very good way to ask a question. Do not type all in
capitals - this is regarded as shouting and is considered rude, as
well as being difficult to read. Also, you do not give specific
details of your data, so any answer will have to make assumptions.

Introduce this formula in a helper column:

=OR(A2=1,A2=2,A2=4)

This assumes that the column you are interested in is column A, so
change the references to suit your data, and it will return either
TRUE or FALSE. Then copy the formula down, and then you can apply
autfilter to this helper column, selecting TRUE from the filter drop-
down.

Hope this helps.

Pete

On Jul 19, 9:08*am, DAVID wrote:
DISPLAYING ALL THE ROWS WHERE THE COLUMN VALUE IS EQUAL TO 1 OR 2 OR 2 OR 4