Listing unique terms from combined strings

This isn't a formula question, it's a VBA question. you would need a macro to parse out each string by the / delimiter and add it to a list if it's new. Here's a simple macro that can do this.... it assumes the data is in column A, it will create a new list for you in column D.

Please Login or Register  to view this content.

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

Nice macro! I used a manual approach that worked ok.
The text to columns feature got rid of the /. Then I added a column to the far right with COUNTA(A1:F1) or whatever range, hence I could get it sorted by no of strings. When that was done it was a few, easy, copy pastes to get it in one column. Then added a column with just ones just to the right, applied the Consolidate feature and got the result.

Hi,

The following macro is one way. Just make sure the list is in column A. The macro will add a new sheet and put the unique values in C1

Please Login or Register  to view this content.

If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.