Deleting Rows with "Total"
Why would you simply delete all of those rows that have Total in them? Don't they have important data in them? You can't just ignore data by deleting it and pretending it is not there!
1 answers ( 0 marked as helpful)
Hi Kurt,
The rows with 'Total' included data that was summarizing the rows immediately above them. So, in order to create a clean database without as many subtotals as rows, I decided to remove them in this case. But you're right, whenever we delete data, we need to be absolutely certain that this wouldn't change the information we have as in this case.
Best,
Ned