Thread: [Solved] A 20k lines Sheet calculation takes 1,23 hours!!
View Single Post
 
Old 11-05-2022, 02:02 PM
fjns fjns is offline Windows 10 Office 2019
Novice
  
Join Date: Sep 2022
Location: Hungary, Szeged
Posts: 16
fjns is on a distinguished road
Default
Hi, in the linked file are two tables with 21000 rows.
SAMPLEorig21000rows.xlsx (with your formulas)
SAMPLEnew21000rows.xlsx (with my formulas)
The product of my test (100% calculation):
SAMPLEorig21000rows.xlsx: 3 minutes
SAMPLEnew21000rows.xlsx: 2 seconds

SAMPLEs21000rows.zip - Google Drive
Last edited by fjns; 11-06-2022 at 02:52 AM.
Reply With Quote