Posted by Jerry on November 12, 2001 11:05 AM
Given Two Columns
Some rows contain blanks, some rows contain duplicate entries. What I want to do is create a single column list of all the data in the two columns less the blanks and duplicate entries, sorted in order. Here's a little wrinkle, if it is possible, I want them to be sorted starting with the last letter/number in the cell.
(In other words, if a cell contains the data GI 5-B3, I want it to look at it like so for sorting purposes: 3B-5 IG)
Thanks for your help!