Thanks, that worked in my attached spreadsheet, however when I implemented that into my actual spreadsheet I'm working on I get #REF or #N/A errors. Says that A2 has a constant. I'm not understanding why if I was able to get it to work in my example spreadsheet but not my actual.