| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name ranges based on criteria
Hi everybody,
I have a large spreadsheet where I want to name ranges in a macro based on the first two digits in the cells of one column. In the example below I need to end up with one named range for the 4 codes starting with 11, one range for the 3 codes starting with 12 and one range for the 2 codes starting with 13. 110003 110024 110035 110594 120012 120014 120045 130455 131004 Any help much appreciated. -- Regards, Martin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
| counting two ranges for one criteria | Excel Worksheet Functions | |||
| Selectively replace cells based on two ranges of criteria - nestedIF() statements? | Excel Discussion (Misc queries) | |||
| sum the values of a range based upon multiple ranges and criteria | Excel Worksheet Functions | |||
| How to put ranges in Criteria.. | Excel Discussion (Misc queries) | |||
![Martin[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
