Finding and eliminating numbers

[khank]

I attached a sample XLSX file.

In column A are 32 "raw" numbers.

D1 and E1 are two numbers (3 and 8).

What I'm wanting to do is eliminate all numbers in Column A which include a 3 and 8 or both (the color coding is only for a visual locater).

Thus leaving in Column G the final 19 revised numbers.

I through it would be some sort of "array" formula or a "pivotal table" (which I have hellva problem with).

Any help?

[MarvinP]

Hi khank,

See the attached that gives you your result using some helping columns and a pivot table.

[stanleydgromjr]

khank,

Detach/open workbook Eliminate Numbers - khank - EF758232 - SDG12.xlsm and run macro EliminateNbrs.

[Marcol]

Try this

In a spare column, say Column J
In J1

Please Login or Register  to view this content.

Drag/Fill Down

Filter this column to exclude blanks

Copy and paste the filtered result to your desired destination (G2?)

Select Column J > Clear All

Hope this helps

[khank]

Thanks to all for your help on this problem. All solutions work. Have a Happy and Safe New Years.