Macro to filter certain values in a column and delete the rest

[willy91785]

Since Excel 2003 only allows for custom filtering of two values, I am looking for the easiest way to filter more than two values. In the attached dummy data, say I wanted to filter on numbers 2,5, and 7 in column 1, and delete the rows that do not meet that criteria, what is the best way to do this? I'm sure a macro would work, or maybe a simple logic match statement?

Thanks for your help.

[StephenR]

A non-macro approach would be to put this formula in column E, sort by E and delete all the 1s:

=IF(OR(A2=2,A2=5,A2=7),"",1)

[willy91785]

That works. Thanks!