FILTERING

  • Thread starter Thread starter DAVID
  • Start date Start date
D

DAVID

DISPLAYING ALL THE ROWS WHERE THE COLUMN VALUE IS EQUAL TO 1 OR 2 OR 2 OR 4
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal and IF Formula 1
filtering with formulas? 3
Using Filter with data in two columns 1
adding text according to col with equal date 2
filtering rows across several columns 1
Filtering column with checkboxes and multiple entries in cells 2
insert row when sum of values equals 100 3
how do you have 2 criterias be picked up in a lookup? 2

Back
Top