I use different formulas and macros to sort/filter an excel s/s. However, I currently have a situation where I have been unsuccessful..I don't think it is difficult, I just can't figure out wysiwyg or programmatically how to solve. Below is the situation.
I have a s/s that has been merged with an updated version of the same s/s.
What I want to do is sort the s/s with the "TC ID" but need to search partially in order to determine duplicates (old rows) that can be removed.
As u can see the first two "TC ID's" have something in commone with the older ones further down... however, how to sort using partial key lookup so they are in the following order: