Forum Discussion

Javilopez1979's avatar
Javilopez1979
Copper Contributor
Apr 07, 2023

filter function between some sheets

Alguien ha usado función filtrar entre tablas de diferentes hojas de Excel? Me da error de calc y no ha nada mal en sintaxis

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    Javilopez1979 

    From the doc.:

    If your dataset has the potential of returning an empty value, then use the 3rd argument ([if_empty]). Otherwise, a #CALC! error will result, as Excel does not currently support empty arrays

Resources