Hello,
Im playing with big numbers of data in Excel. I want to do data cleansing process. How I want to delete certain rows that unnecessary anymore. For example, I have 1 column tag which rows that I want to keep and some to delete. Every tagged rows have its pair row(s) to keep or delete as well.
how did you do the tagging . have you entered texts like "delete" in a column in those rows which You want to delete. in that case fillter whold ata according to this tage and delete filterd data and unfilter.
That is the problem. I got the data from friends to continue the cleaning part after they mark which rows have to be deleted. They tagging not synchronize with a lot of note.
