How to select those records that satisfy specific critiera

Hi, I want to find, and select all those records with the 'Status' (in column B) not equal to 'Closed'. I prefer to do it by functions, rather than having to sort it manually and copy and paste.

To identify the case may be easy, but the challenge is really how to select the whole row and save it some where. In the attached example here, the column A provides the unique code for each case. Columns G, H, I show the results I want to achieve.

Can you please have a look?

Originally Posted by twiggywales

try this

Attachment 205078

with formula (although its not open open waiting waiting its in the order on the sheet)

Hi, twiggywales, your formula really worked. I will read and learn from your example. It will be very useful for me. Thanks a lot.

Originally Posted by Ace_XL

Try this...

- Select your range of data (Columns A:C)
- Apply Autofilter (Alt+D+F+F)
- Column B -- Deslect "Closed"
- Copy Columns A:C
- Paste wherever intended

Thanks, Ace_XL.