hidden_stairway hidden_stairway is offline

Junior Member

Posts: 1

offset function

hello
i am trying to set the reference in an offset function to equal the lowest number in a list without arranging the list in ascending or descending order. i have tried =offset(small(f10:f70,1),0,1,1,1), but it doesnt seem to work... can anyone shed any light on this problem? thanks

brad

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Troubles with the OFFSET function	ghostrider	Excel Worksheet Functions	6	June 1st 05 05:20 PM
help with offset function	Mexage	Excel Worksheet Functions	0	May 24th 05 05:18 PM
Date & Time	mully	New Users to Excel	4	May 23rd 05 11:56 AM
clock	Wildman	Excel Worksheet Functions	2	April 26th 05 10:31 AM
Hyperlinks using R[1]C[1] and offset function in its cell referenc	Elijah-Dadda	Excel Worksheet Functions	0	March 5th 05 03:31 AM

All times are GMT +1. The time now is 03:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us