Forum Discussion
Return data where no data in column on separate sheet
Hi all,
I'm hoping someone can help me before I pull my hair out. I have a sheet with data on it and I need to filter all of the data on a separate sheet where a column is blank.
=IF(FILTER(Sheet1!$A:$P (Sheet1!$M:$M)=""
'If column M on sheet1 is blank then return that data on sheet2'
Sheet1 is the master data and in sheet2 I put in this formula.
On sheet2, I want to return all the columns/data where column M is blank
4 Replies
Here's the syntax (Please adjust ranges to fit your data):
=FILTER(Sheet1!$A$1:$P$1000,ISBLANK(Sheet1!$M$1:$M$1000))Patrick2788 - I adjusted for my data by changing the sheet name to match mine and it returns 0 in each cell from A1 - P1000
It seems to be working. Do you have some sample data in that range to pull back?
I've attached a sample here.
