When requesting a report on my database it saves to excel leaving blanks.
Using sumproduct I can not copy my formula down the column because it seems
that the blank spaces copy the previous adjacent answer until a non blank
result comes up in the column. How can I fix this. I tried copy/paste with
skip blank but that did not work.