Forum Discussion
Solved
Formula to deliver to a different workbook
I am using the formula =FILTER(A2:A20,E2:E20>=1,"NODATA") in order to deliver data from column A to column E of the same sheet, excluding zero results. Is it possible to write a similar formula in a...
=FILTER('[SourceWorkbook.xlsx]Sheet1'!A2:A20, '[SourceWorkbook.xlsx]Sheet1'!E2:E20>=1, "NODATA")
If you must work with a closed source workbook, use Power Query to pull filtered data dynamically.
My answers are voluntary and without guarantee!
Hope this will help you.
Happy Excel-ing!
=FILTER('[SourceWorkbook.xlsx]Sheet1'!A2:A20, '[SourceWorkbook.xlsx]Sheet1'!E2:E20>=1, "NODATA")
If you must work with a closed source workbook, use Power Query to pull filtered data dynamically.
My answers are voluntary and without guarantee!
Hope this will help you.
Happy Excel-ing!
I am SO grateful for this, NikolinoDE. It is going to be extremely useful to me. Thank you!!. And a Happy New Yewar to you!
