• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Short formula, compared with 4 columns

bines53

Active Member
Hello friends ,

Columns A:D, are daily changes in four different stocks.

Columns E:H ,count, the stock has changed several times over 2 percent.

Column J, comparing two lines of Columns E:H .

K3 cell, is the end result.

What I look for is the short formula, the result will be like K3, without the helper columns, E:H and Column J .

Thank you !
 

Attachments

  • test.55.xlsx
    17.9 KB · Views: 1
Last edited:
Hi:

This is what I have come up with. May be someone else will be having a better method.

Thanks
 

Attachments

  • test.55.xlsx
    14.4 KB · Views: 4
Back
Top