Forum Discussion

DK_25's avatar
DK_25
Copper Contributor
Nov 01, 2022

Excel Consolidation

I am doing data input and I need to consolidate the input from my main table to a different sheet in a new table. I need this consolidation to run continuously and continue to add the information as I input on the first sheet. Does anyone know if this is even possible? I have done a lot of research on how to do this using lookup and reference formulas and using the consolidate function. When I try to use the consolidate function and I check the "create links to source data" box it kind of works but it won't add new information to it as I input.

Charting
excel
Formulas and Functions
training
  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Nov 02, 2022

    Hi DK_25 

     

    if you work with Excel from Microsoft 365, some of the new dynamic array functions might be a solution. 

    Depending on the exact requirments this could be one of the FILTER or VSTACK function. Especially if the source/input data is formatted as a table, FILTER or VSTACK would be really dynamic and the output data grows when the input data grows.

Resources