Results 1 to 3 of 3
  1. #1
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: delete row corrupt data (Excel 2002)

    <hr>
    one column is volts, currents, time and Amphours
    <hr>

    Is volts, currents, time, and amphours all in one column or is that 4 different column? If those are in different columns, the data you posted makes it look like there are 5 or 6 columns of data not four.

    What do you mean by "corrupt"? Normally corrupt is used to mean that the worksheet contains some corruption which causes Excel to malfunction. Is that what you mean, or do you mean that some rows contain incorrect data? If so, how is the incorrect data to be recognized?

    If the data is in 5 or 6 columns, and the rows with incorrect data have one or more of those columns empty, could you just sort the worksheet on one of those columns to put all the rows with empty columns together and then just select and delete those rows?
    Legare Coleman

  2. #2
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    delete row corrupt data (Excel 2002)

    Edited by HansV to add <!t>[pre]<!/t> and <!t>[/pre]<!/t> tags

    The following is just a snippet of about 7 000 entires, I didn't notice this until now....The original file is corrupt with about 4 or 5 of these little miscues of information. I am graphing this information, one column is volts, currents, time and Amphours. Is there a post that can help with finding an empty cell then deleting the entire row?
    Thanks Darryl.
    <pre>Full NoChg 3:34:50 1.6 3.18 -0.04
    Full NoChg 3:35:00 1.6 3.18 -0.04
    Full NoChg 3:35:10 1.6 3.18 -0.04
    Full NoChg 3:35:20 1.6 3.18 -0.04
    49.7' ,NoChg,4 -48
    Full NoChg 3:35:30 1.6 3.18 -0.04
    Full NoChg 3:35:40 1.6 3.18 -0.04
    Full NoChg 3:36:00 1.7 3.18 -0.14
    Full NoChg 3:36:10 1.7 3.18 -0.14
    </pre>


  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: delete row corrupt data (Excel 2002)

    Legare,

    Thanks, some times the easiest way is the best way.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •