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

      • fomagnoma's avatar
        fomagnoma
        Copper Contributor
        Feb 07, 2023

        To be clear, VStack can only be entered as a function in Excel online in a browser. Once entered, the results can be seen when using Excel on the Desktop. There are some caveats, however. For instance, if you use a VStack function in a conditional format, you would of course enter that conditional formula in Excel online. Once you opened that file in Excel Desktop, and entered data that would trigger the conditional format, the format would not visibly change in the desktop edition and no errors are thrown. You can actually have the browser version and the desktop version both open at the same time and, while entering data in either shows updates in the other, the conditional formatting only shows its results in the browser version.

Resources