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
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.
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.
Related:
- Delete certain data from Excel
- Transfer data from one excel worksheet to another automatically - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Tmobile data check - Guide
- Delete my whatsapp account without app - Guide
- Gif in excel - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 11, 2012 at 08:55 PM
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.
Hiffzunnuri
Posts
2
Registration date
Sunday November 11, 2012
Status
Member
Last seen
November 11, 2012
Nov 11, 2012 at 11:54 PM
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.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 12, 2012 at 12:25 AM
Nov 12, 2012 at 12:25 AM
can ou post or copy small extrct of what you got and explain again
