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 !
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
Last edited: