Previous Topic Next Topic

Delete certain data from Excel

Closed
Hiffzunnuri
Posts
2
Registration date
Sunday November 11, 2012
Status
Member
Last seen
November 11, 2012
 - Nov 11, 2012 at 07:49 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 - Nov 12, 2012 at 12:25 AM
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

Answer 1 / 3
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 808
Nov 11, 2012 at 08:55 PM
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.
0
Answer 2 / 3
Hiffzunnuri
Posts
2
Registration date
Sunday November 11, 2012
Status
Member
Last seen
November 11, 2012
Nov 11, 2012 at 11:54 PM
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.
0
Answer 3 / 3
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 808
Nov 12, 2012 at 12:25 AM
can ou post or copy small extrct of what you got and explain again
0