Question: I have been attempting to figure out a formula to skip blank lines when I am referencing a list of parts for a bill of materials. The problem I've been running into is where the parts list is being held is updated based on what is selected and then transferred to the actual bill of materials there are blank spaces because some machines have more or less parts. I need to skip these and go to the next line and continue with the cells from there. So if I go from Cell if A1:A24 are filled and A25:A29 are blank and A30 has data I want to skip until it gets to A30 and continue on from there (A30:A35).

Answer: 
While none of the answers in [Project fails to load due to missing SqlServer.targets file after upgrading to Visual Studio 2013](https://stackoverflow.com/questions/20006482/project-fails-to-load-due-to-missing-sqlserver-targets-file-after-upgrading-to-v) worked for me, and nobody else had ideas here on Stack Overflow, it turns out this was a bug related to backwards compatibility in Visual Studio 2013 and SSDTs (SQL Server Developer Tools). A comment in this forum solved my issue:

<https://connect.microsoft.com/SQLServer/feedbackdetail/view/979839>

> 
> Posted by bsclifton on 11/15/2014 at 7:18 AM
> 
> 
> Had this issue too with the Community 2013 edition; Going to Tools->Extensions and Updates and updating "Microsoft SQL Server Update for database tooling" resolved the issue :)
> 
> 
>
Changed .sqlproj file with following as per the advised on other stack workflow thread. Worked for me.

$(MSBuildToolsPath) to $(MSBuildBinPath) in import tag