EASIER WAY TO FILTER

[meppwc]

I have a column on my spreadsheet for "COST CODES"
That list can have over a thousand different values that are repeated multiple times.
I have the need to filter that column to include several hundred of those values and the only way I know to do it, is to pull down and search for each value one at a time, and continuously select "ADD CURRENT SELECTION TO FILTER".
Needless to say, this is very time consuming and I have to perform this exercise often.
Is there an easier way of performing this task?

 

[saboh12617]

Hello,

There are many ways:

Using the FILTER formula (with a "filter list")
Using PowerQuery (with a "filter list table")
Using VBA
…

It depends on the output you expect, and what you want to do with it.

 

[meppwc]

If I use the FILTER formula, I am not sure where to input the formula.

 

[FormR]

You could put list list of 100 codes to filter a spare column (or even a different sheet) and use a helper column to check if the "Cost Code" is in that list. You could then filter on the helper column.

For example>

Book1
	A	B	C	D	E
1	Codes	Helper to Filter On			Fillter List
2	3	FALSE			5
3	9	TRUE			7
4	1	FALSE			8
5	3	FALSE			9
6	9	TRUE
7	1	FALSE
8	5	TRUE
9	4	FALSE
10	7	TRUE
11	7	TRUE
12	2	FALSE
13	8	TRUE
14	9	TRUE
15	6	FALSE
16	4	FALSE
17	9	TRUE
18	6	FALSE
19	2	FALSE
20	9	TRUE
21	3	FALSE
22	1	FALSE
23	4	FALSE
24	10	FALSE
25	5	TRUE
26	7	TRUE
27	9	TRUE
28	9	TRUE
29	6	FALSE
30	8	TRUE
31	8	TRUE
32	1	FALSE
Sheet1

Cell Formulas
Range	Formula
B2:B32	B2	=ISNUMBER(MATCH(A2,$E$2:$E$5,0))

 

[meppwc]

I am not trying to find out if the values exist. I need to filter a huge list of over 10,000 rows to only include specific cost codes.

 

[FormR]

Hi, I understand what you are trying to do and the method I've described is one way that you could achieve it.

You would add the helper column and apply a filter where that column is TRUE to filter the list for the 100's of codes you listed elsewhere on the sheet.

 

[meppwc]

OHHHHHHH.............now I got you................working on it right now.