Filtering Based on a Column of Data?

[joewell]

I need to filter out the rows that do not contain a value from a column on another worksheet.

I can only see how to filter based on a single text value.

Any ideas?

Scenario: I have a list of videos, and I want to remove from the list those videos that were not still online, based on a list.

 

[My Aswer Is This]

Joewel: Any time you seeks answers here you need to provide specific details like:
1. Both sheet names[
2. The columns of data we are working with.
You gave no specific details.QUOTE=joewell;4628612]I need to filter out the rows that do not contain a value from a column on another worksheet.

I can only see how to filter based on a single text value.

Any ideas?

Scenario: I have a list of videos, and I want to remove from the list those videos that were not still online, based on a list.[/QUOTE]

 

[joewell]

Sorry, more specifically:

Sheet2 contains a single column A with no header.

For example:

ZhXotz1k1ls-65

gH0wNvZh1q4-21

GwXlbiAOabQ-73

BwSxIfwPU8U-166

ncoSRKoU6GQ-60

v2hYaJjjDw8-167

v2hYaJjjDw8-170

cEphxIUT_nc-13

cEphxIUT_nc-19

sqr_f6lvBCs-71

vqWUliDaYrA-34

VMR8FNeHGwE-16

<colgroup><col></colgroup><tbody>
</tbody>

In Sheet1, I want to filter all rows that do NOT contain one of the values from Sheet2 Column A above.

In Sheet1, those values would be found only in Column C, with header, "VideoID," for example:

VideoID

xvgcFlGn9_c-164

68wE6Oppt7c-323

A-DOwLnQ4nk-16

CW-5-1WK9dc-34

CW-5-1WK9dc-52

ZhXotz1k1ls-65

gH0wNvZh1q4-21

GwXlbiAOabQ-73

BwSxIfwPU8U-166

ncoSRKoU6GQ-60

v2hYaJjjDw8-167

v2hYaJjjDw8-170

cEphxIUT_nc-13

cEphxIUT_nc-19

sqr_f6lvBCs-71

vqWUliDaYrA-34

VMR8FNeHGwE-16

_zCKfSor2Ig-38

iZ0vcdevzQI-9

xeVlAPXedJ0-358

fqAh-6-0ih0-116

gTIC6ihxNLc-16

EZhjWztb2G8-43

kbrv5ET7UgY-209

4gBYcTpg9es-760

AufJunNmisk-499

a0yJmN2S3OU-48

3QWx7xJ_HRg-452

p7T_qB8C8bw-380

wfiBICAWdQ8-489

b0ciLKx66p4-45

b0ciLKx66p4-347

LhrVZFM_q0o-227

ZakLOzCfMnY-234

lJ9KR97JYa4-339

Q5jU2DPSzWM-502

IzTuz0mNlwU-47

zKhEw7nD9C4-25

Qj0fUHRTsyg-254

ax96cghOnY4-33

NvGTCzAfvr0-58

Gn2pdkvdbGQ-138

W581OBM9rAY-98

sSE6_fK3mu0-26

3GYv-BZYYdg-79

n4EK92CSuBE-63

HEH_oKNLgUU-52

IZ8W-h764Cc-104

IZ8W-h764Cc-124

N4kDzoQOngY-5

N4kDzoQOngY-68

5fkh01mClLU-65

jKg5oFQXdJU-22

PhHWmehThg8-25

PhfbEr2btGQ-40

OiNh2DswFt4-21

GR2GA7chA_c-154

pb8vGcMlRmU-24

#NAME?

jFSenp9ueaI-49

DLki68uLfjw-69

JB3rjgqsKHk-19

ikrizyWN-Uw-358

9urEOfE-1SE-54

7y2KsU_dhwI-313

qINwCRM8acM-63

qINwCRM8acM-224

qINwCRM8acM-300

qINwCRM8acM-440

gt9Y0RTydKY-50

gt9Y0RTydKY-1009

gt9Y0RTydKY-1637

1o3fcUH-yPQ-331

1o3fcUH-yPQ-337

bHKZ3Y9qO_Q-19

UNHQ7CRsEtU-246

kQFKtI6gn9Y-46

kQFKtI6gn9Y-74

HOM17DDOBtI-70

<colgroup><col></colgroup><tbody>
</tbody>