Forum Discussion
Large File and Need to Have Formulas
Hi Everyone - I am working on a large data file and was looking for a schematic (or list) of how exactly excel formulas work For example: =if(B2=1,1,0) - would just look at one column (B)...
Can you expand further on what you mean by "a schematic that has the order of formulas working". All aggregation, logical and lookup/reference formulas will work, it depends on what you are trying to calculate.
One warning is that an excel should not be treated as a database, as it is very limited and the runtime to do any operation is longer and more prone to crashes. If you are interested in different schematics to work with your data, I would recommend indexing your data to make it more manageable. For example, separating the large file into different tables/spreadsheets that can then be joined and queried through PowerQuery or VBA.