Excel 2003 - define name like a filtered list
 

I have a worksheet containing the dates of public holidays in two countries
as a 3-column array: A=country, B=holiday name, C=date. The dates are the
primary sort key.
I need to assign an individual name to the sub-range for each country for
use in the WEEKDAY function. What is the simplest way to do that without
physically sorting the array by country?

Excel 2003 - define name like a filtered list
 

I'm not sure what you're doing this for, but I'd use a macro...

But before I invested any time doing this, I'd what to know that the next step
(where I'd use that name) would actually work with a non-contiguous multi-area
range name.



Hershmab wrote:

I have a worksheet containing the dates of public holidays in two countries
as a 3-column array: A=country, B=holiday name, C=date. The dates are the
primary sort key.
I need to assign an individual name to the sub-range for each country for
use in the WEEKDAY function. What is the simplest way to do that without
physically sorting the array by country?

--

Dave Peterson