Search:

Type: Posts; User: BrSuthe; Keyword(s):

Search: Search took 0.00 seconds.

  1. Counting Odd and Even numbers in a comma-separated list

    Is there a formula(s) to count Odd and Even numbers in a comma-separated list? please. (The list may have numbers up to 20. Single or double digit positive numbers only).
    Thank you.
  2. Re: Leaving empty cells if output is blank with a macro

    Thank you very much! I'll use it, as you said, I realized the cells are not blank in this case.
  3. Re: Leaving empty cells if output is blank with a macro

    I use this macro at a couple of worksheets. One of them has this range: I3:Y13.

    Sorry, I corrected the range.
  4. Re: Leaving empty cells if output is blank with a macro

    and is there a sample macro code like this to delete blanks that you can provide, or you can refer me to?
  5. Re: Leaving empty cells if output is blank with a macro

    thanks, Fluff. Is it possible to add another macro at the end of this one, so when the first one is done, second one executes and makes the deletions?
  6. Leaving empty cells if output is blank with a macro

    I have the following macro. Everything is ok with it, I just need to leave empty cell if there is no output (no values/numbers). Is it possible to do this? Can I get some help, please? Thanks.

    In...
  7. Re: Conditional Formatting two cells when they are equal to a certain value

    I have values like S0, S1, S2, S3, S4 in these two columsn. I use this formula to be exact =AND($BD14="S0",$BE14="S0")
    The first 13 rows are empty. On my sheet, it highlights but it is like...
  8. Conditional Formatting two cells when they are equal to a certain value

    This may seem simple to you, but I'd like to get a little help on this please.
    I have A and B columns. I'm trying to format the two adjacent cells when they have the value "S0".

    What I tried is...
  9. Re: Counting the number of matches including repeats

    I correct my previous post. I made a mistake in counting. The formula gives 7, and it is correct. These numbers repeat.
    <tbody>
    1

    1

    1

    3
  10. Re: Counting the number of matches including repeats

    I am sorry about the cross-posting. I needed to get a quick reply so I did post twice.
    and you are right about your example. In this case, it should be 6. but the formula gives 7. so it is not what...
  11. Re: Counting the number of matches including repeats

    Thanks, everybody for your help. I tried them, but didn't get the result I wanted. I found a solution though. Here it is:
    =sumproduct(--isnumber(match(a1:h1,a2:h2,)))
    Thanks again!
  12. Counting the number of matches including repeats

    I need a formula to count the number of matches between two ranges even some numbers repeat itself. For example, if in row1 ( 1,1,1,3,3,4,2,8) and row2(1,2,3,4,5,5,7,7). Here there are 4 unique...
  13. Replies
    1
    Views
    158

    Re: Number filter / selection

    I forgot to mention that if any boxes are left empty, they should be ignored in the calculation. And the last fives boxes named Dec-0 to Dec-4 can have values from 0 - 6, so they are a little...
  14. Replies
    1
    Views
    158

    Number filter / selection

    I have a table to pick numbers according to their attributes. What I normally do is to use filtering, but it is not very efficient and comfortable to use. I've attached the excel file with the table...
Results 1 to 14 of 14