If it's only the first two characters you want to check, and the data is in column A, in another column type:
=OR(EXACT(LEFT(A1,2),"E"&CHAR(64+ROW(INDIRECT("1:2 6")))))
and press Ctrl+Shift+Enter and then fill down. Now filter that column for TRUE, and delete the visible rows. (or filter for FALSE and copy visible data to a new sheet)
|