Simple spreadsheet, complex problem for me, a total math failure, novice.
I have a sheet with two columns.
Column a describes one of 5 or 6 attributes of sequentially numbered documents.
Column b tells me what documents match those attributes.
Some documents may match several of the column a attributes. Some may match none.
Problem is that column b is currently populated either with individual numbers (ok) or with "ranges" of numbers expressed as,for example, 1-23 or 7-715 etc.
also not every number in the sequence is necessarily represented by any column a attribute.
what I would like to do is fix this sheet to list all numbers, singly and sequentially as one column, and, have another column next to it that lists next to each number the attribute or multiple attributes that it has matches per the current sheet column a.
Is this possible?
How?
Thanks for ideas!
John
Bookmarks