I have a worksheet with rows of information. The start cell of each row
(in column A) has a part number which may or may not contain a suffix.
The suffix is usually of the format "part#_1" or "part#AT" for example.
In other words the same part number maybe repeated and I distinguish
the repeats with an alpha suffix or underscore and numeral. The
problem I'm having is sorting the sheet by column A, part#, and those
part numbers with their suffixes. The suffixes cause the sort to list
the all "number only" part# to be at the top followed by a separate
list of the suffixed numbers in numerical order at the end. You have
to remember to scroll to the end portion of the listing to see if their
are any additonal part number variables to the originating one since the
rest of the data in those rows may contain different information. How do
I get the numbers to sort properly with the suffixed following their
respective parent part#?


--
axlmastr
------------------------------------------------------------------------
axlmastr's Profile: http://www.excelforum.com/member.php...o&userid=26880
View this thread: http://www.excelforum.com/showthread...hreadid=401136