Excel help

[Mark M]

Is there anyway I can compile a list based on an IF statment?

Ive got a list of clients and I want to pull out onto a seperate worksheet any that contain "ltd" or "limited"

If having 2 variables is a problem I can change all the ltd's to limited with a find and replace.

Thanks

 

[Mark M]

Wow that works perfectly thanks! Never used an advanced filter before but it was pretty easy to do once I worked out you had to put *limited* in the criteria.

The only bit I cant seem to work out is whether its possible to put *limited* OR *ltd*

Any ideas? If not I can just find and replace and Ltd's

EDIT - Ive cracked it! You can add another criteria underneath the first one and just change the criteria range to include the new addition.