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?