Matching and deleting data in 2 columns

[rain-a-shine]

I have two columns. Column A is a list of counties that I am using in my study. Column B is the names of the counties that I have data for and Column C has the values of the data. Is there a way to delete entries in Column B and C if they don't match up with one of the entries in Column A? Let me know if I need to clarify. Thanks in advance for your help



Example:

ColumnA
A
C
E
F
H

ColumnB
County
A
B
C
D
E
F
G
H

ColumnC
employment rate
Corresponding numbers are in this column

[greggy99]

its better to attach sample workbook...

[rain-a-shine]

Here is my workbook. If the county in column B does not match with a county in column A I would like to delete that county in column B along with its value in column C.

Thanks!

[newdoverman]

I haven't done the deletions for you but have shown the formula to use and the results. Now all you have to do is to columns B, C, and D using column D as the sort column. Delete the rows that don't have an entry in column D.