Forum Discussion

skim_milk's avatar
skim_milk
Copper Contributor
Jun 28, 2023

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(S...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Jun 28, 2023

skim_milk 

Here's the syntax (Please adjust ranges to fit your data):

 

=FILTER(Sheet1!$A$1:$P$1000,ISBLANK(Sheet1!$M$1:$M$1000))

 

 

  • skim_milk's avatar
    skim_milk
    Copper Contributor
    Jun 28, 2023

    Patrick2788 - I adjusted for my data by changing the sheet name to match mine and it returns 0 in each cell from A1 - P1000

    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Jun 28, 2023

      It seems to be working. Do you have some sample data in that range to pull back?

      I've attached a sample here.

      • skim_milk's avatar
        skim_milk
        Copper Contributor
        Jun 28, 2023

        Patrick2788 

         

        Here you go...

         

         

        Thanks!

         

Resources