| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort a list with a formula
Is there a way to sort a column with a series of formulas? ie select the
range and return the lowest value in row 1, next value in row 2 etc. The range may contain blanks, which should sort to the bottom. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort a list with a formula
you could use LARGE or SMALL but why?
-- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... Is there a way to sort a column with a series of formulas? ie select the range and return the lowest value in row 1, next value in row 2 etc. The range may contain blanks, which should sort to the bottom. Thanks in advance! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort a list with a formula
I am attempting to automate a forecasting model as much as possible without
the need for users to presort their phase numbering There may be multiple occurances of the same sort character(s) so SMALL will not work without some additional logic. For example, the list: 01 02 01 03 should sort to 01 01 02 03 "Don Guillett" wrote: you could use LARGE or SMALL but why? -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... Is there a way to sort a column with a series of formulas? ie select the range and return the lowest value in row 1, next value in row 2 etc. The range may contain blanks, which should sort to the bottom. Thanks in advance! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort a list with a formula
This works well if the data begins in row 1. Is there a way to compensate for
data that does not start in row 1? "Don Guillett" wrote: try =SMALL($G$1:$G$4,ROW()) -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... I am attempting to automate a forecasting model as much as possible without the need for users to presort their phase numbering There may be multiple occurances of the same sort character(s) so SMALL will not work without some additional logic. For example, the list: 01 02 01 03 should sort to 01 01 02 03 "Don Guillett" wrote: you could use LARGE or SMALL but why? -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... Is there a way to sort a column with a series of formulas? ie select the range and return the lowest value in row 1, next value in row 2 etc. The range may contain blanks, which should sort to the bottom. Thanks in advance! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort a list with a formula
try
=SMALL($G$2:$G$5,ROW(A1)) -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... This works well if the data begins in row 1. Is there a way to compensate for data that does not start in row 1? "Don Guillett" wrote: try =SMALL($G$1:$G$4,ROW()) -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... I am attempting to automate a forecasting model as much as possible without the need for users to presort their phase numbering There may be multiple occurances of the same sort character(s) so SMALL will not work without some additional logic. For example, the list: 01 02 01 03 should sort to 01 01 02 03 "Don Guillett" wrote: you could use LARGE or SMALL but why? -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... Is there a way to sort a column with a series of formulas? ie select the range and return the lowest value in row 1, next value in row 2 etc. The range may contain blanks, which should sort to the bottom. Thanks in advance! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort a list with a formula
Thanks Don, that was too easy!
"Don Guillett" wrote: try =SMALL($G$2:$G$5,ROW(A1)) -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... This works well if the data begins in row 1. Is there a way to compensate for data that does not start in row 1? "Don Guillett" wrote: try =SMALL($G$1:$G$4,ROW()) -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... I am attempting to automate a forecasting model as much as possible without the need for users to presort their phase numbering There may be multiple occurances of the same sort character(s) so SMALL will not work without some additional logic. For example, the list: 01 02 01 03 should sort to 01 01 02 03 "Don Guillett" wrote: you could use LARGE or SMALL but why? -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... Is there a way to sort a column with a series of formulas? ie select the range and return the lowest value in row 1, next value in row 2 etc. The range may contain blanks, which should sort to the bottom. Thanks in advance! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort a list with a formula
Glad to help
-- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... Thanks Don, that was too easy! "Don Guillett" wrote: try =SMALL($G$2:$G$5,ROW(A1)) -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... This works well if the data begins in row 1. Is there a way to compensate for data that does not start in row 1? "Don Guillett" wrote: try =SMALL($G$1:$G$4,ROW()) -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... I am attempting to automate a forecasting model as much as possible without the need for users to presort their phase numbering There may be multiple occurances of the same sort character(s) so SMALL will not work without some additional logic. For example, the list: 01 02 01 03 should sort to 01 01 02 03 "Don Guillett" wrote: you could use LARGE or SMALL but why? -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... Is there a way to sort a column with a series of formulas? ie select the range and return the lowest value in row 1, next value in row 2 etc. The range may contain blanks, which should sort to the bottom. Thanks in advance! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort a list with a formula
I meant to say, glad to help a fellow Austinite.
-- Don Guillett SalesAid Software "Don Guillett" wrote in message ... Glad to help -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... Thanks Don, that was too easy! "Don Guillett" wrote: try =SMALL($G$2:$G$5,ROW(A1)) -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... This works well if the data begins in row 1. Is there a way to compensate for data that does not start in row 1? "Don Guillett" wrote: try =SMALL($G$1:$G$4,ROW()) -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... I am attempting to automate a forecasting model as much as possible without the need for users to presort their phase numbering There may be multiple occurances of the same sort character(s) so SMALL will not work without some additional logic. For example, the list: 01 02 01 03 should sort to 01 01 02 03 "Don Guillett" wrote: you could use LARGE or SMALL but why? -- Don Guillett SalesAid Software "Steve-in-austin" wrote in message ... Is there a way to sort a column with a series of formulas? ie select the range and return the lowest value in row 1, next value in row 2 etc. The range may contain blanks, which should sort to the bottom. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Single formula to 'sort' a list onto a second sheet? | Excel Worksheet Functions | |||
| Alpha sort excel mail list | Excel Discussion (Misc queries) | |||
| Sort with a List | Excel Worksheet Functions | |||
| Sort with a List | Excel Worksheet Functions | |||
| HELP: Data > Validation ---List ----Formula | Excel Worksheet Functions | |||
Linear Mode
