Boards
News
Market Data
Markets
Discover
Discover
AI Subscribe Login/Register account icon
S&P 500
7,123.64
(
0.84%
)
US TECH 100
26,154.00
(
1.48%
)
Dow Jones
49,372.87
(
-0.15%
)
Brent Oil
96.75
(
1.83%
)
Bitcoin
79,061.99
(
3.58%
)
News Focus
News Focus
Post# of 17625
Next 10
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

capt_jmj

Send PM Follow Ignore
Followers 27
Posts 4012
Boards Moderated 2
Alias Born 03/22/2006

capt_jmj

Re: tclark1 post# 2953

Monday, 05/01/2006 4:07:57 PM

Monday, May 01, 2006 4:07:57 PM

Post# of 17625
TC, I think I figured it out, at least it didn't screw anything up...

MAX(INDIRECT(ADDRESS(ROW(X78)-$S$15,COLUMN(X78),4)):X78)

Which is equivalent to MAX(X69:X78) when $S$15 is a user input variable set to 9

Kind regards,
-CAPT J

"What would you attempt to do if you knew you could not fail?"

http://investorshub.advfn.com/boards/board.aspx?board_id=7383

Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Discover What Traders Are Watching

Explore small cap ideas before they hit the headlines.

Join Today