Does anybody know if it's possible to take a selection of cells and 'sort' them by, say, a given word?
For example, say I've got 200 phrases, all relating to 'widgets', 'sprockets' and 'doohickeys', but aren't separated in to groups. Is there a way to tell Excel to arrange them in a column in such a way that 'sprockets'-related phrases are ordered first, followed by 'widgets' and 'doohickeys' etc?
For example, say I've got 200 phrases, all relating to 'widgets', 'sprockets' and 'doohickeys', but aren't separated in to groups. Is there a way to tell Excel to arrange them in a column in such a way that 'sprockets'-related phrases are ordered first, followed by 'widgets' and 'doohickeys' etc?