Excel 2003 - define name like a filtered list

  • Thread starter Thread starter Hershmab
  • Start date Start date
H

Hershmab

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting examples from a table 6
Advanced Filter 1
Excel 2010: How to display PivotChart Report Filter Lables on the graph 2
Nested Ifs & NetworkDays Combined Functions 4
Multiple instances of a named range, not in the list 4
Cascade Drop-Down Lists? 1
Print range 3
macros or formulas not sure 6

Back
Top