Sort table B by Table A's IDs

[IronCladRooster]

Hello

Simple question for you. I have two tables - Table A and Table B. Table A has just a few entries in it while Table B has a much larger data set (including all of the entries in Table A). I want to filter Table B to just show me the rows that match Table A's items. What is the best way to go about doing this?

This is a dumbed down version of an exercise I need to do. A VLOOKUP or any kind of searching won't work. I need to filter Table B in place.

I've actually found a way to do this by using the advanced filter, but since in my data set Table A has 350 rows and Table B has 5,000+ rows it's just a little inconvenient to add a ton of rows above Table B and advanced filter that way.

See attached for example

Thanks in advance.

[MarvinP]

Yep,

Advanced Filters is the method I'd use. Instead of filtering in place, why don't you try to filter the answer to another range of cells (to the right of your tables). You might even look at Dynamic Named Ranges for your two tables to make the problem easier when the number of rows grows for either table.

[jaslake]

Hi IronCladRooster

This Code is in the attached and appears to do mostly what you describe...CTRL + x will fire the Code.

Please Login or Register  to view this content.

[shg]

You could add a column to Table B and filter for TRUE:

Row\Col	J	K	L	M	N
8	ID	Important piece of information	Formula
9	6	$97,756	#N/A		L9: =LOOKUP([@ID], TableA[ID])=[@ID]
10	9	$51,310	#N/A
11	13	$84,290	#N/A
12	14	$95,457	#N/A
13	14	$61,379	#N/A
14	18	$66,909	#N/A
15	19	$75,238	TRUE
16	21	$55,824	FALSE
17	22	$61,068	FALSE
18	24	$90,160	FALSE
19	27	$63,494	TRUE
20	31	$68,747	FALSE
21	34	$59,831	FALSE
22	44	$56,027	TRUE
23	49	$93,621	FALSE
24	50	$69,122	FALSE
25	54	$57,409	FALSE
26	61	$63,600	FALSE
27	67	$83,192	FALSE
28	77	$65,791	FALSE
29	82	$52,434	FALSE