Excel Formula to Alphabetize Unique items only from a list

broshannon,

what you describe will most likely require VBA. In this article http://www.contextures.com/excel-dat...ation-add.html you can probably find some pointers to get you on the right track.

If you find that this is beyond your current level of Excel expertise, you can come back here for assistance, but be advised that unless you truly understand how a solution works, you will not be able to adjust it if your requirements or parameters change.

cheers,

Depending on how you want to pursue this then another route would be to use some basic helper cells rather than VBA - see attached.

How practical / scalable a formula driven approach is rather depends on volume of data in the original duplicate list.

If the process is a one off exercise and source list does not change then using an intermediate Filter step makes sense

edit:

in retrospect - in the attachment - would be better to add a pre-emptive IF to the formulae in Column C

Please Login or Register  to view this content.