Stock market trends – pivots

2 Responses to “Stock market trends – pivots”

  1. Appreciating the commitment yyou put intfo your website and in depth information you
    offer. It's awesome to come across a blog every omce in a while thatt isn't the
    same old rehashed material. Wonderful read! I've bookmarked your site annd I'm including your RSS feeds to mmy
    Google account.

  2. In addition, you should use the decoction as a face wash.
    If an individual has longer hair, then try to prevent it
    from touching a person's skin. If you would like to remove them naturally, it is important for you to check this article out
    that gives better information on how to solve the problems of acne scars naturally.

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