two formulas needed

[SplatP1]

Hello,

I'll try my best to explain this:
First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then return a 0.
Second formula needed in Sheet3 cell A1: Copy all the rows of Sheet1 that have a 1 in A:A. Preferably with no empty rows in Sheet3, just the data list.

This is driving me nuts, so any help is really appreciated.
Cheers.

 

[Fluff]

Thanks for that.
How about
=FILTER(Report_Master!C2:AD83233,Report_Master!A2:A83233<>1)

 

[SplatP1]

it returns #NA

 

[Fluff]

Not sure why you would get a #N/A error
What is the range of data you want to pull from the report_master sheet?

 

[SplatP1]

B1:Y83233

 

[Fluff]

In that case try
=FILTER(Report_Master!B1:Y83233,Report_Master!A1:A83233<>1)

 

[SplatP1]

Still the same.

 

[Fluff]

I do not understand why you would get that error
Do you have a UDF (user defined function) called Filter?
Do you have the new dynamic array function, like Filter, Sequence, Sort etc?

 

[SplatP1]

I dont think so. As you can tell, I'm not an expert, and those things you mentioned are not familiar to me.
How do I check?

 

[Fluff]

If you type =Seq into a cell, do you get Sequence as one of the options in the drop down?

 

[SplatP1]

yes