George Andrews

Posts: n/a

Indirect Row & cell formula

Excel 2000

Can anybody correct this formula which is not working for me.

=MAX(C450:INDIRECT("plan!C"&ROW(cell("rows")))

I am trying to get the maximum value from the range C450 and the Activecell
Row in column C

thanks.

George

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
up to 7 functions?	ALex	Excel Worksheet Functions	10	April 12th 05 06:42 PM
Can a Formula in Cell X modify Cell Y?	alMandragor	Excel Discussion (Misc queries)	7	February 10th 05 09:51 PM
looking for a formula	Amanda	Excel Worksheet Functions	5	January 5th 05 07:37 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
can i colour a cell on basis of results of a formula e.g clour bl.	K	Excel Worksheet Functions	3	November 4th 04 06:18 PM

All times are GMT +1. The time now is 01:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us