+ Reply to Thread
Results 1 to 11 of 11

Removing rows containing zeros

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    15

    Removing rows containing zeros

    Hello Fellows,

    Couple of days ago, some fellows at Excel forum helped me to find out maxima of a sine wave. The method also somehow included points that were close to maxima. So I used IF condition to remove such erroneous points (see attachment column D, E and F). I tried to use this data further for my analysis but apparently I cannot do it until I remove all the rows with zeros in it like row # 6, 7 and 8. Please suggest some procedure to carry out this task.

    Secondly, I have plotted voltage maxima vs. time steps. I want a plot without blue curve (time) and x-axis with time stamps 0.0094, 0.0442 and 0.0788 instead of 1, 2 and 3.

    Third, If I want to hide coulmns D, E and F using a 'plus' sign to expand or hide these columns, how I can do it?

    Any help and suggestion will be much appreciated, thanks in advance!!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Removing rows containing zeros

    And attachment

  3. #3
    Registered User
    Join Date
    06-13-2012
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Removing rows containing zeros

    testing.xlsx

    Here you go!

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Removing rows containing zeros

    You can filter out 0 values?
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-13-2012
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Removing rows containing zeros

    Ahhh yess thanks that can work I guess! But how did you put the expand hide button on the top?

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Removing rows containing zeros

    Select columns you want to group (D, E, F)
    Go to Data -> Group

  7. #7
    Registered User
    Join Date
    06-13-2012
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Removing rows containing zeros

    Thanks man, any idea how to change x axis from 1, 2, 3 to actual time of sine wave?

  8. #8
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Removing rows containing zeros

    Right click on X axis values -> Select data

    And for Horizontal (Category) Axis Labels click Edit and select data in B column.
    Is that it?

  9. #9
    Registered User
    Join Date
    06-13-2012
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Removing rows containing zeros

    Yes!!

    One more thing if you can help with... I just checked using the results from filter. The other columns where I want to use the data are still using the data of some rows which were filtered out. Like in the attached file G9 is using H9 and H8 in the formula whereas I want to make it H9 and H5 (the rows in between have been filtered and there data is useless).

    Can you suggest some function which can copy the results of the filter in another columns OR change the formulas as per the results of the filter?
    Attached Files Attached Files

  10. #10
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Removing rows containing zeros

    I've got some, but I don't know is it that:

    Instead of your formula where it look H9-H8 and B9-B8 I put to use H9 and B9 and last value where D column is not 0.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    06-13-2012
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Removing rows containing zeros

    Thanks its working fine!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1