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!
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!
you could use LARGE or SMALL but why?
--
Don Guillett
SalesAid Software
[email protected]
"Steve-in-austin" <[email protected]> wrote in message
news:[email protected]...
> 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!
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
> [email protected]
> "Steve-in-austin" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
>
try
=SMALL($G$1:$G$4,ROW())
--
Don Guillett
SalesAid Software
[email protected]
"Steve-in-austin" <[email protected]> wrote in message
news:[email protected]...
>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
>> [email protected]
>> "Steve-in-austin" <[email protected]> wrote in
>> message
>> news:[email protected]...
>> > 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!
>>
>>
>>
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
> [email protected]
> "Steve-in-austin" <[email protected]> wrote in message
> news:[email protected]...
> >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
> >> [email protected]
> >> "Steve-in-austin" <[email protected]> wrote in
> >> message
> >> news:[email protected]...
> >> > 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!
> >>
> >>
> >>
>
>
>
try
=SMALL($G$2:$G$5,ROW(A1))
--
Don Guillett
SalesAid Software
[email protected]
"Steve-in-austin" <[email protected]> wrote in message
news:[email protected]...
> 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
>> [email protected]
>> "Steve-in-austin" <[email protected]> wrote in
>> message
>> news:[email protected]...
>> >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
>> >> [email protected]
>> >> "Steve-in-austin" <[email protected]> wrote in
>> >> message
>> >> news:[email protected]...
>> >> > 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!
>> >>
>> >>
>> >>
>>
>>
>>
Thanks Don, that was too easy!
"Don Guillett" wrote:
> try
> =SMALL($G$2:$G$5,ROW(A1))
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Steve-in-austin" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >> [email protected]
> >> "Steve-in-austin" <[email protected]> wrote in
> >> message
> >> news:[email protected]...
> >> >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
> >> >> [email protected]
> >> >> "Steve-in-austin" <[email protected]> wrote in
> >> >> message
> >> >> news:[email protected]...
> >> >> > 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!
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
Glad to help
--
Don Guillett
SalesAid Software
[email protected]
"Steve-in-austin" <[email protected]> wrote in message
news:[email protected]...
> Thanks Don, that was too easy!
>
> "Don Guillett" wrote:
>
>> try
>> =SMALL($G$2:$G$5,ROW(A1))
>> --
>> Don Guillett
>> SalesAid Software
>> [email protected]
>> "Steve-in-austin" <[email protected]> wrote in
>> message
>> news:[email protected]...
>> > 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
>> >> [email protected]
>> >> "Steve-in-austin" <[email protected]> wrote in
>> >> message
>> >> news:[email protected]...
>> >> >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
>> >> >> [email protected]
>> >> >> "Steve-in-austin" <[email protected]> wrote
>> >> >> in
>> >> >> message
>> >> >> news:[email protected]...
>> >> >> > 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!
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>
I meant to say, glad to help a fellow Austinite.
--
Don Guillett
SalesAid Software
[email protected]
"Don Guillett" <[email protected]> wrote in message
news:%[email protected]...
> Glad to help
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Steve-in-austin" <[email protected]> wrote in
> message news:[email protected]...
>> Thanks Don, that was too easy!
>>
>> "Don Guillett" wrote:
>>
>>> try
>>> =SMALL($G$2:$G$5,ROW(A1))
>>> --
>>> Don Guillett
>>> SalesAid Software
>>> [email protected]
>>> "Steve-in-austin" <[email protected]> wrote in
>>> message
>>> news:[email protected]...
>>> > 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
>>> >> [email protected]
>>> >> "Steve-in-austin" <[email protected]> wrote in
>>> >> message
>>> >> news:[email protected]...
>>> >> >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
>>> >> >> [email protected]
>>> >> >> "Steve-in-austin" <[email protected]> wrote
>>> >> >> in
>>> >> >> message
>>> >> >> news:[email protected]...
>>> >> >> > 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!
>>> >> >>
>>> >> >>
>>> >> >>
>>> >>
>>> >>
>>> >>
>>>
>>>
>>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks