Quote Originally Posted by Debraj Roy View Post
Hi dt32,

can you please upload a sample small file for the same.. as your formula is full of Relative & Absolute ref mixture..
OK.. i replaced the names with cities and deleted all sensitive information for this attachment. I did notice that I get a result if I delete column D. These two are not right next to each other in the overall spreadsheet though, so I added the blank to illustrate my problem. I can't add an attachment at work so I have added the dropbox link.

https://www.dropbox.com/s/x3gjtqj9mh...20example.xlsx