Forum Discussion

littlevillage's avatar
littlevillage
Iron Contributor
Aug 21, 2022
Solved

How to filter values 0 in an array

Hi, I need to filter values 0 in an array, and hope the result a dynamic array I have added an image and the link of sample file Hope for your help Thank you    
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Aug 21, 2022

    littlevillage Change the first variable "x" in the LET formula to this:

    x,UNIQUE(FILTER(Table1[Column1],Table1[Column1]<>0)),
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 21, 2022

littlevillage Change the first variable "x" in the LET formula to this:

x,UNIQUE(FILTER(Table1[Column1],Table1[Column1]<>0)),
  • littlevillage's avatar
    littlevillage
    Iron Contributor
    Aug 21, 2022

    Riny_van_Eekelen 

    it's unbelievable, you make it so simple

    Thank you so much

Resources