Have you ever struggled with modifying your Excel document while on the go? Well, DocHub has an excellent solution for that! Access this cloud editor from any internet-connected device. It allows users to Tack cross in Excel files quickly and whenever needed.
DocHub will surprise you with what it offers. It has robust functionality to make any changes you want to your paperwork. And its interface is so straightforward that the whole process from start to finish will take you only a few clicks.
As soon as you complete modifying and sharing, you can save your updated Excel document on your device or to the cloud as it is or with an Audit Trail that contains all adjustments applied. Also, you can save your paperwork in its original version or turn it into a multi-use template - complete any document management task from anyplace with DocHub. Subscribe today!
heres our cross tabulated report with products in the columns employees in the rows and the intersection are total sales and guess what if we add new records to the bottom of our excel table it instantly updates add more data and it keeps on updating so in this video were going to see how to use the new beta functions h stack and v stack to help us create a single cell cross tabulated report now if you dont have the latest beta and you still want to create this single cell formula if you have microsoft 365 i have other videos about how to do this but guess what theyre much more complicated than the h stack and v stack methods also the big caveat anytime you create a report like this with formulas is that a formula report is much harder to create than a pivot table report but if you need your solution to update instantly when source data changes worksheet formulas are the only tool that can do that now before we create our formula i want you to notice something about this report the