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
Bookmarks