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]

In that case you have dynamic arrays
What do you see if you type =fil into a cell?

 

[SplatP1]

filter and filterxml

 

[SplatP1]

I added an IFERROR and it shows the attached.

 

[Fluff]

Would you be able to supply to workbook?

 

[SplatP1]

yes, let me change some data, need a few minutes.

how should I share it?

 

[Fluff]

You will need to upload to a share site such as OneDrive, GoogleDrive, DropBox. Then mark for sharing & post the link to the thread.

 

[SplatP1]

Thanks for your patience Fluff

report_master_Fluff.xlsx

drive.google.com

 

[Fluff]

Ok, thanks for that.
The problem is you have a load of #N/A values in col A. If you change the formula in col A to
=IFERROR(--(Dash!$B$2=B2),"")
And use this formula
=FILTER(report_master!B1:Y83233,report_master!A1:A83233=1,"No Data")

 

[SplatP1]

Legend! Cheers mate.
Thanks a lot

 

[Fluff]

You're welcome & thanks for the feedback