Formulas seems not to be calculated
I have a big sheet of ~11000rows by 30 columns (an asset register)
I added 2 columns to calculate the duplicates =IF(COUNTIF([L2]$1:[L2]@row, [L2]@row) > 1, 1, 0) and to select the rows to show in a filter =IF(AND([DuplicateL2]@row = 0, NOT([L2]@row = "")), 1, 0)
Copying/pasting or Selecting + CTRL+D the formulas has been already a Graal quest. I had to do it bit by bit. Many times the web page needed to be reloaded.... it took me almost a day.
There is not sign that the sheet is calculating when the formulas are copied. to the point I decided to fill the value 1 & 2 in 2 cells and try to add them in a third cell. No result showed up even after 1 minute.
Am I doing something wrong? Are there limitations that I do not know about?
Is there a way to force the calculation of formulas (like F9 in excel)?
Thanks for the advises and support
Help Article Resources
Check out the Formula Handbook template!