Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create named range
I have a worksheet with rows of data. Col. A contains a
number. I sort the entire list by Col. A then I want to create a named range for each change in Col. A. For example, if Cells' A1, A2, and A3 all contain 999, then I want to take all the Col. A cells with 999 and create a named range of "999". Then, if Cells' A4, A5, A6, and A7 all contain 888, then I want to take those 4 cells and create a named range of "888". Any suggestions on the most efficent way to perform this task? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a dynamic named range? | Excel Discussion (Misc queries) | |||
#value! error trying to create a simple dynamic named range | Excel Discussion (Misc queries) | |||
how do i create a named range excluding particular cells | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Using a formula to create named range reference | Excel Worksheet Functions |