Here is an example. I want to check row 8 ("Price move") to see whether a
value greater than 1 or less than -1 comes first, and return "up" or "down"
in a specified cell based on which comes first ("up" if 1 comes first and
"down" if -1 comes first).
Eventually I want to check the next 30 value
Let me rephrase: Eventually I'll have one of two words in a row of cells
(e.g. "up" or "down") and I want to know which one comes first. How can I
get Excel to tell me whether the *first* instance of "up" or "down" comes
in an earlier column?
--
FORUM RULES (986+ members already BANNED for vio
0 Apr 2012 20:26:18
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Find column # of first value greater than
specified value?
Here is an example. I want to check row 8 ("Price move") to see whether a
value greater than 1 or less than -1 comes first, and return &q
IF(SUMPRODUCT((B8:AE8<>1)*B8:AE8)<1,"down","up")
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Filip Houdek
Sent: Monday, April 30, 2012 10:26 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Find column # of first
illett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Filip Houdek
> *Sent:* Monday, April 30, 2012 10:26 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Find column # of first value greater than
> specifi
: $$Excel-Macros$$ Re: Find column # of first value greater than
specified value?
Hello, I'm confused about that response. I don't know how SUMPRODUCT would help
here. Could you explain a bit?
Thanks
On Tuesday, May 1, 2012 8:42:57 AM UTC-4, Don Guillett wrote:
IF(SUMPRODUCT((B8:AE8<