+ Reply to Thread
Results 1 to 11 of 11

Help need to check mark + Eliminate blank cells

  1. #1
    Forum Contributor Anka's Avatar
    Join Date
    08-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016
    Posts
    174

    Help need to check mark + Eliminate blank cells

    Hello to everybody.

    First of all congratulations for the forum.

    I am from Portugal. I do not know much (even less) about excel, vba or macros. Unfortunately my English is horrible. But I'm persisted and I hope with your help to be able to finish this.
    In the attached picture I tried to explain exactly what I do.

    Thank you in advance.

    Anka


    PS: I tried to adapt some formulas what I found here, but no chance. Fail.
    Attached Images Attached Images

  2. #2
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Help need to check mark + Eliminate blank cells

    Can you upload a worksheet and details of exactly you require!

  3. #3
    Forum Contributor Anka's Avatar
    Join Date
    08-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016
    Posts
    174

    Re: Help need to check mark + Eliminate blank cells

    Hi Kevin.

    Thank you for your interest in helping me.
    Basically I want to know how to do the following things.

    I not believe that it is very difficult ... for who knows. I just got to a point .. but I lack the knowledge to finish.
    Now I upload my Excel. In it I explained what I do and what I want.
    1 - How to make can check to both sides, A-B maybe at the same time but not necessarily ?
    2 - How to made that values to settle one under the other (J10 to down) without whites cells.

    Thanks in advance.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Help need to check mark + Eliminate blank cells

    Maybe with an pivot table.

    I see you used merged cells.

    Don't use them, you get in trouble, sooner or later.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Forum Contributor Anka's Avatar
    Join Date
    08-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016
    Posts
    174

    Re: Help need to check mark + Eliminate blank cells

    Thanks for your quick answer oeldere.

    I used merged cell just one example to see how to do, maybe II will need in the future. In fact I will use only one side: A or B.
    I think your solution is very good but I want to use the mark checked. My calculator is not used for simple operations.
    Let's say if I combined mark cats with dogs know what weight is their fur. It's just an example.

    Anyway thank you.

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Help need to check mark + Eliminate blank cells

    If it is just an example, learn to built a table like the example.

    It get mutch easier to make an pivot table with that.

    It is mutch easier to use a formula to get the right result.
    Attached Files Attached Files

  7. #7
    Forum Contributor Anka's Avatar
    Join Date
    08-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016
    Posts
    174

    Re: Help need to check mark + Eliminate blank cells

    Because my English is very bad, it is hard to explain why I want to do in this way.
    If you can explain how to do to put the checked values one under the other in the column of ​​my calculator .. I would be very helpful.

    Thank you.

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Help need to check mark + Eliminate blank cells

    I don't have an solution for that.

  9. #9
    Forum Contributor Anka's Avatar
    Join Date
    08-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016
    Posts
    174

    Re: Help need to check mark + Eliminate blank cells

    No problem.
    Thank you very much for your time spent in helping me.
    (I) Wait for other opinions.
    Last edited by Anka; 08-29-2012 at 01:59 PM.

  10. #10
    Forum Contributor Anka's Avatar
    Join Date
    08-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016
    Posts
    174

    Re: Help need to check mark + Eliminate blank cells

    If someone may be just explain me how to do to get checked values ​​one below another in another column .. It would be very helpful. Come on, guys.

  11. #11
    Forum Contributor Anka's Avatar
    Join Date
    08-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016
    Posts
    174

    Re: Help need to check mark + Eliminate blank cells

    Solved.
    If anyone is interested you can find the solution here.

    Solved with the help of mike7952.

    Great job. Many thanks.
    Last edited by Anka; 08-29-2012 at 03:46 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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