00:00In my recent video, I showcased the process of consolidating data from multiple sheets in Excel.
00:04However, one of my viewers proposed an alternate approach utilizing the Unique and Summive function.
00:09Like everything else in my Excel journey, I had to try it and share what I found along the way.
00:14To achieve data consolidation solely through function, I discovered that three formulas are necessary to achieve the outcome.
00:20The first formula is to get unique fruit from all three tables using VStack nested in Unique function.
00:25VStack vertically combines the fruit name column and the Unique filter outs duplicate values ensuring only distinct fruits are retained.
00:33The second formula comprises of two parts.
00:35Firstly, it involves creating a prep table by vertically combining all columns from all tables using a VStack function.
00:41Secondly, we utilize the Summive function to calculate the total quantity for each fruit type based on the result obtained
00:47from the VStack function.
Comments