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 1863 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 responses

Answer 1 / 3
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 12, 2012 at 12:25 AM
can ou post or copy small extrct of what you got and explain again
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses