Register
Log In
Unanswered
Home
New Member
May 17, 2017
Offline
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.
November 8, 2013
Offline
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
Most Users Ever Online: 57
Currently Online: Ali Bokhari
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ali raza
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
