My output specifies a range to overwrite...for example (a:c), and when I validated the data I noticed that there is a duplicate on the last row. On an other sheet with similar rules for output the data has multiple duplicate rows, and on another sheet it has a duplicate row with completely false values in the columns.
I did a lot of tinkering around with removing duplicates and cleansing data to remove leading or training whitespace. I thought I had fixed it, then when I go to run the report the next day with new data, I find that the problem still persists.
To solve this I had to remove the range of the output. When I removed the range it summed everything up perfectly with no duplicates. However, I would really like to have those formulas that are now no longer on my sheet that was completely overwritten.
Has anyone else come across this problem? It seems strange that I would have completely different output just because I got rid of the range.
