slow formula

hi friends! I currently am sorting my sheet like the attached page. Basically I have a few unique numbers, want to add a comment next to it, then lookup the value against full columns where the number exists in the data table in col I&J. Then I want to add the comment to each replicate of the...

Hi all, My workbook is getting very slow, especially when i insert rows or enter new data for example. Is there a faster way to achieve the same result? I hope the formulas are translated correctly from dutch to english. Formula 1...

I have a file where one second the entire workbook only takes a couple seconds to calculate everything, but every now and then it will suddenly take an unreal amount of time to process, and will continue doing this. I have played around with this and it will happen without any changes to the...

I have an issue where a ranking formula using multiple criteria is slowing my spreadsheet to a halt every time i change the input formula. The formula is as follows: =SUMPRODUCT(--($B$6:$B$18222=B6), --($CI6<$CI$6:$CI$18222))+1 Now the column CI6 is another formula that changes depending on...