My apologies NBVC, I tried that formula on the example that I provided and it did work. I tried it on my real spreadsheet and it didnt work. It may be because I started where I left off at when doing it manually instead of from the beginning. I will try that now.