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
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