Mike, I've been having issues with a tracking spreadsheet I'm working on. I found your function concatif, and it works great! One problem though, having it installed breaks a beforedoubleclick event function that I wrote for it. I can't figure out why this is happening and I'm getting desperate lol. Any advice you can offer? Here is the original post. http://www.excelforum.com/excel-prog...ing-there.html