I've attached a sample workbook to help illustrate my needs. The workbook has a master list of data on one tab (named "List") which lists various "fields" used in a file naming convention. Our file names follow a sequence of "Type-Major-Minor-Status_Description" and as such the master list of data has columns to help indicate which use/category each field falls in.
What I'm trying to do is place the fields on a new tab (and eventually a separate file entirely), sorted into columns based on their intended use/category to make the lists more readable. There are a few select fields that have multiple uses/categories and would need to appear in mulitple columns on the separate tab.
Unfortunately, my attempts thus far by using simple IF statements and Index/Match formulas are not yielding the desired result. Index/Match seems to only grab a single (first found?) result and the simple IF statements leave blank cells. I also tried more complicated IF statements but I had no luck there either. Maybe I'm just doing something wrong, but as I've erased my faulty formulas in disgust, I cannot share them.
I'm trying to avoid VBA/macros, likewise I'm avoiding anything that requires the info to be duplicated. An Array Formula is how I'd like to handle this, if possible.
The sample file has been simplified, but it contains enough info to illustrate the type and format of the data set I will be working with. I do expect there to be numerous changes so the ideal solution is for the data to be dynamically sorted into appropriate columns as changes are made on the master list.
If this can't be handled in the manner I'm seeking, I'd love to hear and learn why. I'm definitely open to suggestions, whether it be how to reorganize the data so that these desired methods work properly or even an entirely different method of sorting the info.
Thanks in advance!
Happy Holidays!
Bookmarks