| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define Range Names in Excel 2003-SP2 | Excel Discussion (Misc queries) | |||
| Automatically define a list of words in Excel? | Excel Discussion (Misc queries) | |||
| Define a range containing the first 10 rows of a filtered list | Excel Worksheet Functions | |||
| how can I rank within a filtered list in Excel? | Excel Discussion (Misc queries) | |||
| Filtered list in Excel 2002 | Excel Discussion (Misc queries) | |||
Threaded Mode
