I have a list of part numbers that we are constantly using... and I am trying
to make a list of them and just want these part #'s to go in
numeric/alphabetical order as they are entered. Is there a way to do this?
I have a list of part numbers that we are constantly using... and I am trying
to make a list of them and just want these part #'s to go in
numeric/alphabetical order as they are entered. Is there a way to do this?
An easy way to sort-on-the-fly is to use a helper column. Say you are
entering part numbers in A1 thru A100.
In B1 put:
=LARGE(A:A, ROW()) and copy down
Column B will be the sort of column A (in descending order). As you enter
items in column A the items in column B will automatically adjust themselves.
--
Gary's Student
"Krystle" wrote:
> I have a list of part numbers that we are constantly using... and I am trying
> to make a list of them and just want these part #'s to go in
> numeric/alphabetical order as they are entered. Is there a way to do this?
Okay, that worked. Thank you. But what if there are letters associated within
the part number I am trying to sort?
"Gary''s Student" wrote:
> An easy way to sort-on-the-fly is to use a helper column. Say you are
> entering part numbers in A1 thru A100.
>
> In B1 put:
>
> =LARGE(A:A, ROW()) and copy down
>
> Column B will be the sort of column A (in descending order). As you enter
> items in column A the items in column B will automatically adjust themselves.
> --
> Gary's Student
>
>
> "Krystle" wrote:
>
> > I have a list of part numbers that we are constantly using... and I am trying
> > to make a list of them and just want these part #'s to go in
> > numeric/alphabetical order as they are entered. Is there a way to do this?
Give me some examples.
--
Gary's Student
"Krystle" wrote:
> Okay, that worked. Thank you. But what if there are letters associated within
> the part number I am trying to sort?
>
> "Gary''s Student" wrote:
>
> > An easy way to sort-on-the-fly is to use a helper column. Say you are
> > entering part numbers in A1 thru A100.
> >
> > In B1 put:
> >
> > =LARGE(A:A, ROW()) and copy down
> >
> > Column B will be the sort of column A (in descending order). As you enter
> > items in column A the items in column B will automatically adjust themselves.
> > --
> > Gary's Student
> >
> >
> > "Krystle" wrote:
> >
> > > I have a list of part numbers that we are constantly using... and I am trying
> > > to make a list of them and just want these part #'s to go in
> > > numeric/alphabetical order as they are entered. Is there a way to do this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks