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?

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