Stock market trends – pivots

One Response to “Stock market trends – pivots”

  1. Again, though there have been many studies done that try to tell us that
    we cannot eat a chocolate bar if we want healthy
    skin or that a slice of pizza is the absolute enemy in the war against acne, there
    is no absolute answer as to which foods cause acne breakouts.
    Mix it until the mixture foams and turns into a paste
    like consistency. Not only will it cause more pimples to
    pop out later, but it will also leave a permanent pimple scar.

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Count identical numbers in two columns but items must be in same row

3 Responses to “Count identical numbers in two columns but items must be in same row”

  1. Indigo says:

    You can use non array formula, like this:

    =SUMPRODUCT((A2:A6=B2:B6)*(A2:A6/B2:B6))

    Try to find another non array formula.

    • Leonid says:

      There is a number of ways to make such a count as non array formula, e.g. =SUM(INDEX((A2:A6=B2:B6)*1,,)). But why not use array formula if it does the job?

  2. Indigo says:

    [quote]Leonid says:

    April 12, 2016 at 6:49 pm

    There is a number of ways to make such a count as non array formula, e.g. =SUM(INDEX((A2:A6=B2:B6)*1,,)). But why not use array formula if it does the job?[/quote]

    I suspect that Kidd has many more rows and columns in his file and CSE formulas are eating resources.

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Compare two columns in different worksheets

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Sort values by corresponding text

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Sort names by value

7 Responses to “Sort names by value”

  1. Leonid says:

    Elegant solution!

  2. Matt says:

    Excellent job Oscar, and not for the first time.

    I like your site.

  3. David says:

    Beautiful formula,
    you're not even an array.

  4. Oscar says:

    Thank you all!

    David, you are right. You don't need to enter the formula as an array formula. I was wrong. Thanks for pointing that out.

  5. Oscar says:

    By the way, substitute the LARGE function with the SMALL function to sort values in ascending order.

  6. Leonid says:

    By adding a small value like COLUMN($A$1:$F$1)/10000 we can handle ties(not array formula entered in A3):
    =INDEX($A$1:$F$1,MATCH(AGGREGATE(14,6, $A$1:$F$1+COLUMN($A$1:$F$1)/10000,ROUND(COLUMN(A1)*0.5,0)),INDEX($A$1:$F$1+COLUMN($A$1:$F$1)/10000,,),0)-MOD(COLUMN(A1),2))

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file