Personal budget tracker, 8000 rows, maybe 15 columns. Every edit hangs for 15 20 seconds before the cell updates. I assumed 8000 rows was tiny. There are a few VLOOKUPs, some SUMIFS pulling from other tabs, and about…
Column D has order references like 4471 and A 4472 mixed together. returns the numeric ones fine and leaves blanks where the text ones should be. If I sort the sheet so text is at the top it flips and drops the numbers…
Trying to flag rows: in F2. I get a result in F2 and absolutely nothing in F3 downwards, not even blanks. If I drag the plain IF down it works perfectly on every row, so the logic is right. What makes ARRAYFORMULA give…
Monthly CSV export from our booking system. The date column looks like 03/11/2025 in every cell, left aligned. Sorting puts 12/01 before 03/11. DATEVALUE works on some rows and throws VALUE on others with no pattern I…
One tab per site, 30 sites, about 1700 rows each and growing monthly. The summary tab currently does VLOOKUP into each tab by name, which means 30 formulas per metric and a rebuild every time a site opens. The…