There are more clever ways to do what you ask, but I would do this by
simple helper columns ( I can understand simple), copy-paste-special
Values, and sort as shown in the attached.
Then I could adapt such formula to other uses.
Hope this helps.
+-------------------------------------------------------------------+
|Filename: helper.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3625 |
+-------------------------------------------------------------------+
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=390037