Forum Discussion

SamB513's avatar
SamB513
Copper Contributor
Jun 01, 2022

Combine Two Filter Functions

I'd like to achieve the following:   Return columns from another sheet A | C | D | E | G (where A is between two figures) and then append (if populated) Y | Z or AA | AB or AC | AD or AE | AF or AG...
excel
Formulas and Functions
cb147852369's avatar
cb147852369
Copper Contributor
Dec 15, 2022

Hi SamB513 have you tried using the vstack function?

  • SamB513's avatar
    SamB513
    Copper Contributor
    Dec 16, 2022

    cb147852369 thanks, vstack never came up in my searches, will look in to it!

    • cb147852369's avatar
      cb147852369
      Copper Contributor
      Dec 16, 2022

      SamB513 I think they only released it to excel a few months ago so it wouldn’t have been coming up as an option  back in May. 

      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Dec 16, 2022

        cb147852369 

         

        SamB513 never mentioned which Excel's version they're working with nor the OS

        FILTER is avail. on 2021 and 365 but VSTACK, HSTACK and the like are only available with 365

Resources