| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there a way to place a row in numeric/alpheberical order?
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Is there a way to place a row in numeric/alpheberical order?
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Is there a way to place a row in numeric/alpheberical order?
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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Is there a way to place a row in numeric/alpheberical order?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I place items in alphabetical order in a column and keep da | Excel Worksheet Functions | |||
| Generate Auto Order Number | Excel Discussion (Misc queries) | |||
| Series order conflicts with line order | Charts and Charting in Excel | |||
| Print order of worksheets | Excel Discussion (Misc queries) | |||
| Maintaining a default worksheet order | Excel Discussion (Misc queries) | |||
Linear Mode
