PSG - You are my HERO for not only the day, week, month but for the year!!!! ....and we are not even half way through the first month. With tweaking the forumla to fit my cells and columns this worked like a charm. Since my blanks were sporadic I filtered that column and pasted the formula...
I know this sounds like a no-brainer; yes I can always Ctrl " or drag the information down or even copy and paste. My issue is I have over 75,000 lines of data and little time to accomplish this task. Not all cells are blank and it is very sporadic.
My question - Is there a formula I could...