+ Reply to Thread
Results 1 to 2 of 2

Can't find the error functions INDEX () and SMALL()

  1. #1
    Registered User
    Join Date
    01-27-2012
    Location
    Asia
    MS-Off Ver
    os x
    Posts
    9

    Can't find the error functions INDEX () and SMALL()

    Hello

    This is a follow up to a thread I started several months ago that now appears to have died. ;-)
    http://www.excelforum.com/showthread...=1#post2694122

    I have run into an issue / bug now that I cannot determine the cause.

    As you will see in the file it builds and automated list based on data in the "sales pipeline" in the "won summary" after it has a date entered in column E

    The master equation is:
    {=IFERROR(INDEX('Sales Pipeline'!$D$6:$D$1003,SMALL(IF('Sales Pipeline'!$E$6:$E$1003<>"",ROW($E$5:$E$204)-4,""),ROW()-4)),"")}

    I have attached the sheet for review but on the "Sales Pipeline" sheet Once any data is added in or below Row 206 Column E the "Sales Pipeline" the "Won Summary" sheets stops working and all goes blank.

    However I can add above Row 206 without any issues.

    I am lost and have tried to evaluate what the cause maybe but have not had any success hope you can help.

    Thank you!
    Hg

    Attachment 151570

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Help fix my file please... Can't find the error functions INDEX () and SMALL()

    Hi Hg,

    You need to just use the correct references in the formula, see the attached file :-

    sampleSample BUG.xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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