Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 48
Default Search a named range

I have numbers in column E8:F65500 which I named RANGE1, N8:O65500
which I named RANGE2.
Column A is numbered 1 to 65500 referencing RANGE1, Column J is
numbered as a continuation of column A 65501 to 131000 referencing
RANGE2.
Let's say I am looking for the minimum in RANGE1 and RANGE2, between
number 62500 and 75000 identified in Column A and Column J. How can I
put that in a formula?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 913
Default Search a named range

On Wed, 26 Aug 2009 21:51:37 -0700 (PDT), rhhince
wrote:

I have numbers in column E8:F65500 which I named RANGE1, N8:O65500
which I named RANGE2.
Column A is numbered 1 to 65500 referencing RANGE1, Column J is
numbered as a continuation of column A 65501 to 131000 referencing
RANGE2.
Let's say I am looking for the minimum in RANGE1 and RANGE2, between
number 62500 and 75000 identified in Column A and Column J. How can I
put that in a formula?



Try this formula:

=MIN(MIN(OFFSET(E1,62500-1,0,65500-62500+1,2)),MIN(OFFSET(N1,0,0,75000-65500,2)))

I have assumed that E8 and N8 are typos and should be E1 and N1.
Otherwise I can't see any natural mapping between numbers 1 to 65500
and the range E8:F65500 and the same for RANGE2.

Hope this helps / Lars-Åke
Reply
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
Referencing a named range based upon Range name entry in cell Barb Reinhardt Excel Worksheet Functions 14 June 20th 07 07:19 PM
automatic range - named range give me circular reference... George Thorogood Excel Discussion (Misc queries) 0 February 22nd 07 08:53 PM
Array as a "named range" - formula ok in cells, but error as "named range" tskogstrom Excel Discussion (Misc queries) 11 December 28th 06 05:44 PM
inserting a named range into new cells based on a named cell Peter S. Excel Discussion (Misc queries) 1 June 4th 06 03:53 AM
Can I use named range in data range box when creating pie chart? BJackson Charts and Charting in Excel 2 August 17th 05 05:37 PM


All times are GMT +1. The time now is 10:16 PM.

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

About Us

"It's about Microsoft Excel"