LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rpp114
 
Posts: n/a
Default Display values set in a range??


I have selected a dynamic range that is defined similar to Values =
offset(a1:150,index_1,index_2,15,1). I want to display the numbers
saved in the Values range. I can get them to display, but when they do
they only appear in the cooresponding row that is looked up. How can I
show the values of the range, where no matter the first value of it, it
will show up in a defined cell?

Basically, I want the numbers stored in the Values range to display in
a1:a15 no matter what the vertical offset is.

If this makes sense thanks, if not I will attempt to clarify.


--
rpp114
------------------------------------------------------------------------
rpp114's Profile: http://www.excelforum.com/member.php...o&userid=34131
View this thread: http://www.excelforum.com/showthread...hreadid=539003

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Use criteria for values in range for small function like2hike Excel Worksheet Functions 1 March 21st 06 04:09 PM
Compare values, display date DeejGCK Excel Worksheet Functions 2 March 16th 06 08:45 PM
Return Range of Numerical Values in Single Column based on Frequency Percentage Sam via OfficeKB.com Excel Worksheet Functions 9 October 28th 05 11:01 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
MIN with zero values in the range Brenda Rueter Excel Discussion (Misc queries) 5 March 15th 05 09:44 PM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"