copy selection to another sheet

[cayang002]

Hi, All,

Thanks for all the help.

I have a five column data with unknown rows. I want to select certain records and copy them into another sheet, my selection cretieria are: column A="A", AND column D="B" or "C", or "#N/A" since it based on a formula. if selection creteria for column D is ""#N/A", just ignore this creteria.

Please help me with this simple question(to you).
Thanks!

 

[texasalynn]

in a blank cell put this formula
=IF(AND(A1="A",OR(D1="B",D1="C")),1,0)
then copy down, filter for the 1
but I don't understand about your #N/A ignore comment.

 

[cayang002]

Thanks for the reply. I've thought the same formula and it works fine except the "#N/A" part. the creteria for column D is come from another range, say, H1:H6, based on different input, any cell in the range can be "#N/A". What I want is if cell is "#N/A", just ignore this cell and select based on next cell in the range.

The selection creteris is as follows:

for Column A for Column D
A D
#N/A"
C

Thanks!

 

[cayang002]

Sorry, the text all mesed up.
The creteris for column A is:A
For column D is: "C", or "D", or '#N/A"

 

[xenou]

Maybe:
=IF(OR(ISNA(D2),A2="A"),1,IF(OR(D2="C",D2="D"),1,0))

?
Alex