Referencing a specific column within a named range

bobwhosmiles

New Member
Joined
Apr 19, 2004
Messages
22
Hi,

If I create a database and name it, does anyone know what the syntax is when entering a formula for referring to a specific column within that range?

eg. Cells A1:F50 are named Database. Row F is filled with dates. I want to find the earliest date in the database so I'll use MIN:

=MIN(Database.....

where do I go from here?

Best,

Bob
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
or


=DMIN(Database,I1,I1:I2)

Where I1 contains your field name
I2 can be blank or could specify a condition
 
Upvote 0
Thanks guys but neither seems to be working and I suspect it has something to do with the fact that Database is a dynamic named range created with :

=OFFSET(INDIRECT(ADDRESS(MATCH(17,Comments!$A$2:$A$5000,0)+1,1)),0,0,COUNTIF(Comments!$A$2:$A$5000,17),16)

in the "Refers to" box of the "Insert Name" dialog, as prescribed by OzGrid Dave

The methods you've suggested work fine on the same page as "Database" but I want the analysis based on another worksheet where they don't seem to be working.

Do you know a way round it?

Bob
 
Upvote 0
You have to include the sheet reference with Database:

Sheet1!Database
 
Upvote 0

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top