Re: Sorting problem
If your part numbers are always 4 characters with possibly some others
as in your sample, you could introduce a new column with the formula
= LEFT(A2,4)
copied down the column for as many rows as you have. You could then
sort on this column first and column A second.
Pete
.
Relevant Pages
- Re: Sorting problem
... Part numbers are not always 4 characters. ... Would your solution work with this? ... Prev by Date: ...
(microsoft.public.excel) - Re: The Three Burials of Melquiades Estrada
... So did the six other people in the theatre with us. ... as to films I've seen this year, and I would have seen it a second time ... Pete is a man who is completely isolated emotionally. ... The LONELINESS of these characters is so intense it reaches out of the ...
(rec.arts.mystery) - Re: - POLL: Should Civil War turn out to be a Peter Parker dream sequence?
... stories more interesting in the long run. ... Considering the fact that I tend to think of these characters as real ... Pete and MJ separated for her ... concept and continuity taking the place of single story with no direct ...
(rec.arts.comics.marvel.universe) - Re: Dump On Parker
... Pete doesn't need to get old, ... more than other characters do. ... Other than an occasional time-travel ... I'll grant that having a hot starlet wife was not quite ...
(rec.arts.comics.marvel.universe) - Re: The Three Burials of Melquiades Estrada
... So did the six other people in the theatre with us. ... as to films I've seen this year, and I would have seen it a second time ... Pete is a man who is completely isolated emotionally. ... The LONELINESS of these characters is so intense it reaches out of the ...
(rec.arts.mystery) |
|
