User Profile
willc8
Copper Contributor
Joined Sep 16, 2022
User Widgets
Recent Discussions
Crashing Spreadsheet
The spreadsheet I'm working currently crashes after about five minutes of working on it. It isn't a memory problem because its not the largest file I currently work with and I checked task manager and it looked like I was fine on RAM and storage. It did however show that my CPU was maxed out when working with the file. I am using some fairly complex formulas such as: ={IF(SMALL(IF(Final!$H$2:$H$18497=Calc!DY$1,Final!$A$2:$A$18497),ROW(28:87))<251,SMALL(IF(Final!$H$2:$H$18497=Calc!DY$1,Final!$A$2:$A$18497),ROW(28:87)),"")} on a large scale. Is it possible that this could be using up all my CPU processing power or is it something else? Side note: I have all other applications closed when I work with this spreadsheet and nothing that I know of is running in the background. Thanks594Views0likes0CommentsFinding bottom 10 values with criteria
Hi all, I'm currently currently trying to pull the bottom 5 values from a table based off of criteria. The criteria is a ID # ex. "1056" and the other data I want to rank is distance. To do this I found this. =small(IF(A2:A20="Value",C2:C20,""),ROW(A1:A10)) I've tried to use it but it just won't work returning the #NUM! error every time. Based off what I could find online I've narrowed it down to some sort of formatting issue but no matter how I try to format my data it wont work. Does anyone have any advice?1.5KViews0likes1Comment
Recent Blog Articles
No content to show