Delete certain data from Excel

[Closed]
Report
Posts
2
Registration date
Sunday November 11, 2012
Status
Member
Last seen
November 11, 2012
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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.

thank you.

3 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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.
Posts
2
Registration date
Sunday November 11, 2012
Status
Member
Last seen
November 11, 2012

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.
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
can ou post or copy small extrct of what you got and explain again