Posted to microsoft.public.excel.worksheet.functions

rhhince[_2_] rhhince[_2_] is offline

external usenet poster

Posts: 48

Referencing a Cell

I like to do some backtesting, but I find it long and tedious to check
a strategy. This is what I would like:

I have a number in B9, ie. 214
I have a number in B10, ie. 274

I have a formula in AT9 which is: =MIN('4 HOUR DATA'!$E215:$F274)

I would like to modify the formula to automatically pick the number
after $E and after $F without manually placing them in.

Is there an excel formula for that?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cell referencing	Michael	Excel Worksheet Functions	3	November 4th 07 01:21 PM
Referencing Cell Next To Today's Date Cell	Docktondad	Excel Discussion (Misc queries)	5	May 16th 07 10:25 PM
referencing a cell	MIchel Khennafi	Excel Worksheet Functions	3	September 8th 06 05:28 PM
Cell Referencing?	Andy	Excel Worksheet Functions	0	June 26th 06 03:07 PM
Cell Referencing	Silver	Excel Discussion (Misc queries)	2	January 11th 05 05:24 PM

All times are GMT +1. The time now is 05:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us