This functional tutorial is endless thanks for video. Apparently, the PQ calculation methodology began to occur in Excel formulas. It has been quite complementary to combine HSTACK and VSTACK formulas with the LAMBDA function. We are able to create this formula with the Office365 with the EXPAND formula. What I want to ask, Can we combine different tables and show the combined tables, repeat to pivot as well as showing which table of these data is coming from?

Thank you that is really interesting. Excel is starting to look better and better compared to google sheets since I don't have any programming skills (I know I should start learning at least one programming language being that it is the future). One question though....when you create those custom formulas in a excel spreadsheet, will you be able to to use those in new workbooks or you have to recreate them each time you are working in a new workbook?

@ExcelGoogleSheets

2 жыл бұрын

You'll have to recreate them in other workbooks.

Hey, can we get the new results in end of data, using vstack

Can we add HANDLEBLANK before VSTACK function only once??

Hi, thank you for this very full of contents tutorial, by the way i don't have both functions HSTACK & VSTACK in the Excel version i use. May i ask you whitch version you do use? Thank's again

@ExcelGoogleSheets

2 жыл бұрын

365 preview

1st comment

Is there a way to do this in Google Sheets?

@ExcelGoogleSheets

2 жыл бұрын

Yes, but not using the same formula.

@natew

2 жыл бұрын

@@ExcelGoogleSheets could you do a video on this or link to one that you recommend? I know the query function could accomplish this. Hard to match column headers though. Keep think dget could get us there as well on sheets.

@ExcelGoogleSheets

2 жыл бұрын

Here is one kzread.info/dash/bejne/dnigypV-fpm0hps.html

@damian4601

Жыл бұрын

​@@ExcelGoogleSheets maybe a part 2 for this? I know {,} and {;} can do the same. They are equivalent to function calls of Array_row and Array_literal.