Forum Discussion
Formula help needed
Hi Malen0125,
I have questions: 1. para ma count nya ang entry sa table , necessary na in convert nya sa power query table? same like validation table.
A. Dili necessary pero it will make it mas sayon. I think the validation table is a static table, meaning it stays the same size dimension only to present values that are aggregated (summarized) related to the details of gathering information, typically most corporate businesses use a pivot table or data model. Since your data set isn't large enough to warrant an expansion of the validation table, you can have it as is, where it is and no need to change it until there's a need for expansion where you can decide on whether you want to used a pivot table that is based on a data model.
2. Is it possible na if naa ko entry in table (new case) automatice sya mo count didto sa table 2 (conso table).
A. Automatic=Dynamic. Para ma dynamic ang update sa table kinahanglan gamiton nmo ang excel formatted table kay pg mg add ka ug new entry mg expand mn ang table automatic, pati ang range sa formula automatic xa mg update.
It looks like job for Power Query if transform entire table. If one by one perhaps SUMIFS() works. But it's hard to be more concrete without sample file and knowing on which version of Excel you are.
