Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
135
Views
I have been using sumif to find & return data to generate monthly reports, however this file now takes a long time to open and/or update each month. I believe the issue is sumif but don't know how to fix the formula or alternatively what formula to use instead of sumif that wont be volitale. Can you please assist? Thank you, Regards.
Posted : 18/05/2017 2:52 am
Hi,
On large data sets, even a simple formula will take a while to recalculate.
You should aggregate data with power query, or even a simple pivot table, that will speed up the process.
Catalin
Posted : 18/05/2017 12:55 pm
