Results 1 to 5 of 5

Thread: Automatically removing rows using a formula?

  1. #1
    Neophyte Bhavna123's Avatar
    Join Date
    May 2019
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2016

    Automatically removing rows using a formula?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I was wondering if anyone could help.

    I have a table to statements with blank rows in between. The table of statements changes automatically as it is referencing another table (which is dynamic depending on the data). I was wondering if there was a way whereby the blank rows are discarded automatically?

    Click image for larger version. 

Name:	Excel help.JPG 
Views:	14 
Size:	35.6 KB 
ID:	9109

    Let me know.

    Thank you

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    137
    Articles
    0
    Excel Version
    2019
    Pictures
    Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.


    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.


    2. Make sure that your desired results are also shown (mock up the results manually).


    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).


    4. Try to avoid using merged cells as they cause lots of problems.


    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

  3. #3
    Neophyte Bhavna123's Avatar
    Join Date
    May 2019
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2016
    Hello,

    Thank you for your response. I have now attached an excel sheet. The score will change depending on the subject. There is a bandings for each score and each category is then grouped as a weakness or a strength. In the report, descriptions are shown for only those that are described as a "Weakness". What I want the output to disregard are the blank rows automatically which may change if the Scores are different. Hope it makes sense! Thank you in advance

    I wasn't able to attach an excel workbook so I have added it only google sheets and below is the link. Thank you!!
    Last edited by Pecoflyer; 2019-05-16 at 07:25 AM. Reason: Removed external link

  4. #4
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    137
    Articles
    0
    Excel Version
    2019
    I've looked at your worksheet and read your explanations. I have no idea what you want based upon what you have presented. Please try and explain step by step what you are trying to achieve. Please be specific using the example you presented as an example.

  5. #5
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,636
    Articles
    0
    Excel Version
    2010 on Xubuntu
    @Bhavna
    Hi and welcome
    as external links are not safe and not all our members can open them, please post on the forum
    Click "Go advanced - Manage attachments" and follow the wizard.
    Thanks
    Thank you Ken for this secure forum.

Posting Permissions

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