User Profile
willc8
Copper Contributor
Joined 3 years ago
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. Thanks581Views0likes0CommentsFinding 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.4KViews0likes1Comment
Recent Blog Articles
No content to show