Posted to microsoft.public.excel.misc

Stan

external usenet poster

Posts: 150

offsets (I think)

I have found a value using the MAX formula and would now like to return the
value found in the cell one row above and one column before the original
position of this result. Is this possible?

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
Cinditional formatting question - offsets	Pete Rooney	Excel Discussion (Misc queries)	5	April 24th 08 05:07 PM
Countif & Offsets	Yuanhang	Excel Discussion (Misc queries)	1	February 15th 08 09:16 PM
"internal margin" and axis offsets (excel 2007)	jv_chile	Charts and Charting in Excel	8	February 11th 08 05:31 PM
Image (object) offsets in Web show mode	Anders	Excel Worksheet Functions	0	November 13th 06 10:14 AM
average, array and offsets	Darin1979	Excel Worksheet Functions	0	November 17th 04 04:21 PM

All times are GMT +1. The time now is 11:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us