the part numbers are 13 characters long ..
Aha, if these are actually alphanumerics, then no.
The auto-sort earlier works on numbers

I don't see a corresponding +1 in the revised B2 formula.
That's because it's a slightly different approach.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Compass Rose" wrote in message
...
The sorting change that you made doesn't work, probably because, for the
sake
of simplicity of the original post, I simplified the part number. In fact,
the part numbers are 13 characters long and, for example, appear as
follows:

17400100000HW
or
106A01000009S
or
508008P-R(R)W

which I assume renders your sort method ineffective.

I should also mention that my data starts in row 10, which meant that I
changed the original B2 formula to

=IF(ROWS($1:1)COUNT(A:A),"",INDEX(Sheet1!X:X,SMAL L(A:A,ROWS($1:1))+9))
changing the +1 to +9 at the end of the formula. I don't see a
corresponding
+1 in the revised B2 formula.

Your help on this and time devoted is truly appreciated.

David