Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
list unique substrings
Hi All:
I have several dynamic named ranges (DNR) that I copy from a datasheet to a calculation sheet. I am attempting to build a matrix where the row-headings are the first three characters of the first DNR and the column headings are the last two characters of the first DNR. The matrix would then populate using concatenate & vlookup. Right now it is working using worksheet functions for the mid, concat & vlookup. However, the number of observations I have is changing enough that I would like to make it dynamic in VBA. Thanks for your help. James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula (not adv. filter) to list unique values from list | Excel Worksheet Functions | |||
Macro to apply parsing rules for strings and list the substrings | Excel Worksheet Functions | |||
How to pick out unique components in a list with unique and common | Excel Discussion (Misc queries) | |||
Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
sum wrt substrings! | Excel Worksheet Functions |