New Excel Functions 2022 VSTACK and HSTACK

preview_player
Показать описание
You've heard of the new Excel functions in beta right now, and here's a look at two of them:

VSTACK and HSTACK

To use these functions you will need only decide whether you want to combine two arrays vertically or horizontally and then enter the appropriate formula.

Want to vertically stack two arrays? Then use =VSTACK(Array1,Array2)

Want to horizontally append two arrays? Then use =HSTACK(Array1,Array2)
Рекомендации по теме
Комментарии
Автор

thank you so much❤
I love YouTube for such a content. I will propose my employer to reimburse me costs for YouTube subscription and recognize it as “expenses for learning materials” or “optimisation costs” 😂

jammy
Автор

Was using filter xml before this will be amazing 🤩

willm