Results 1 to 10 of 10

SMALL IF Formula crashing file?! Can't figure this out!

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2020
    Location
    Virginia
    MS-Off Ver
    MS 365
    Posts
    12

    Question SMALL IF Formula crashing file?! Can't figure this out!

    My co-worker and I have been racking our minds over this for the last week and have no idea what's going on. A file I've been sending out every week for the last year suddenly doesn't work for everyone other than me; they open it up, change a value to toggle the output and then excel crashes. I've rebuilt the file 4 times and still it doesn't work, so it's not due to hidden names or external links. It looks like it may be due to a =SMALL(IF(),ROW()-ROW()) formula which works fine on my end and is a formula I use often that I've never had problems with (i use it in other files I send out weekly that no one has issues with).



    Does anyone have any ideas why this would occur? I've attached the file after removing any confidential info but it likely will not work for you. When people change cell D5 to 101-129 it crashes. The formula in question is : =IF($A7>$A$5,"",SMALL(IF(Data!$B$6:$B$511=$D$5,Data!$C$6:$C$511),ROW($C7)-ROW($C$6)))
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel file crashing on open
    By anasttin in forum Excel General
    Replies: 1
    Last Post: 05-16-2020, 06:28 PM
  2. Excel File crashing
    By mayoman157 in forum Excel General
    Replies: 1
    Last Post: 11-28-2017, 01:34 PM
  3. Excel crashing when trying to view code before macro run; not crashing after first run
    By goonerforlyf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2015, 05:27 PM
  4. Replies: 4
    Last Post: 02-03-2014, 08:05 AM
  5. Sum formula to exclude monthly budget figure when actual figure is entered
    By rocketmail in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2013, 04:22 AM
  6. why is it my excel file is always crashing?....
    By tweety127 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-02-2006, 06:26 PM
  7. File crashing when opening another
    By LAF in forum Excel General
    Replies: 0
    Last Post: 02-02-2005, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1