vstack

Hi, first of all, sorry for my bad English. I have been looking for a solution here, trial and error by myself, and the Microsoft forum as well. But haven't found any solution that satisfies the needs. I think it's possible but I don't know how to put it into Excel formula. The logic is like...

I want VSTACK to return the FILTER formulas across spreadsheets (same location), not the values. Is that at all possible?

Hello there! (this is my first post, so I expect to fail at being clear.. apologies in advance! I also will write inelegantly and breach the formatting etiquette: I apologise for that too) I have a problem with creating a single formula that produces a single dynamic array which combines...

Hello, I'm new to Excel. I tried a google search and I don't think I'm asking the right questions. Google did lead me here where I did a forum search. However, the one post that showed up wasn't really relevant to my situation. I have a workbook with 9 worksheets. The first worksheet is just a...

I have a workbook with sheets for each financial year from 2010 onwards. All column headers are the same across all sheets. I need to be able to combine all the sheets into one sheet *BUT* I need this combined sheet to change with the others if rows are added/deleted in any of the other sheets...

I have 2 tables on separate tabs that I would like to search for any row containing a criteria and return the whole row. After converting the data to tables I create a new tab just for my search and am using cell B3 as my search criteria text box. I am using the following formula and no matter...

Sheet1: Sheet: 123: Basically I need a formula that takes all the lines that have 123 in column "I" on sheet1 to fill on sheet "123" starting in B12. I need columns K:Q to transfer over as well as the Debit/Credit columns. However, instead of the description column from Sheet1, I would like...

I am building a workbook that will build a BOM off of several different selection variables (21) from the user. the user output is a list of table names that correspond to the tables i want to vstack(). this is what i have so far. The aim is for this workbook to contain no macros. i have the...

On sheet A I have columns containing names which are created using SPILL formulas. The header for each column is a date. 2/5/23 2/12/23 2/19/23 2/26/23 3/5/23 Petr Blincko Avram Lukas Erinna Fossord Juana Cater Forrest Spencers Myrle Cossar Ashlen Tremonte...

Hi, Is there a better way of using vstack but ignoring the empty cells in each list that this; VSTACK(FILTER(Table2[A],Table2[A]<>""),FILTER(Table2[B],Table2[B]<>""),FILTER(Table2[C],Table2[C]<>"")) Richard.

I am testing the new dynamic array functions (CHOOSECOLS and VSTACK) and I am trying to combine them with SUMIFS. I am trying to display in cell C2:D22 with SUMIFS the number of kudos from the respective student and sport. However, Excel does not allow up this formula. If I just run the SUMIFS...