Need a formula to sort without using a macro
 

I have a sheet that records daily test results for one month. On any given
day there can be 1-10 entrees. Currently I have a column that we put an x in
and then I have macros recorded to sort and put them in order acording to
date. My problem is my version of excel is old enough I can not password
protect this page because I then get errors during the sort. From what I have
read I need a newer version of Excel and all the VB code I have found does
not work with my current version. My company has decided not to purchase a
newer version as of yet. I was wondering if there is a formula that I can
use to put the chosen dates in order with out using a macro. When these test
are run and recorded I only need one of the results entered in the daily
report form. Since I have formulas on this ss I and I can not protect it
employees are starting to change formulas so I need this passworded.
Thanks Scott

Need a formula to sort without using a macro
 

Hi,
the only way is to do it manually, highlight all your range to be sorted and
the Data Sort, choose here the date column and done

"scott" wrote:

I have a sheet that records daily test results for one month. On any given
day there can be 1-10 entrees. Currently I have a column that we put an x in
and then I have macros recorded to sort and put them in order acording to
date. My problem is my version of excel is old enough I can not password
protect this page because I then get errors during the sort. From what I have
read I need a newer version of Excel and all the VB code I have found does
not work with my current version. My company has decided not to purchase a
newer version as of yet. I was wondering if there is a formula that I can
use to put the chosen dates in order with out using a macro. When these test
are run and recorded I only need one of the results entered in the daily
report form. Since I have formulas on this ss I and I can not protect it
employees are starting to change formulas so I need this passworded.
Thanks Scott

Need a formula to sort without using a macro
 

Thanks but I want to elimanate any human contact other that my own to do the
sorting....and I am not checking this daily....That is why I thought some
sort of formula..Thanks again

"Eduardo" wrote:

Hi,
the only way is to do it manually, highlight all your range to be sorted and
the Data Sort, choose here the date column and done

"scott" wrote:

I have a sheet that records daily test results for one month. On any given
day there can be 1-10 entrees. Currently I have a column that we put an x in
and then I have macros recorded to sort and put them in order acording to
date. My problem is my version of excel is old enough I can not password
protect this page because I then get errors during the sort. From what I have
read I need a newer version of Excel and all the VB code I have found does
not work with my current version. My company has decided not to purchase a
newer version as of yet. I was wondering if there is a formula that I can
use to put the chosen dates in order with out using a macro. When these test
are run and recorded I only need one of the results entered in the daily
report form. Since I have formulas on this ss I and I can not protect it
employees are starting to change formulas so I need this passworded.
Thanks Scott

Need a formula to sort without using a macro
 

You don't need a macro to sort dates. For example, If in A1 thru A14 we have:

1/9/2009
1/4/2009
12/25/2008
12/27/2008
12/24/2008
1/3/2009
12/31/2008
1/7/2009
1/2/2009
12/30/2008
1/5/2009
12/22/2008
1/6/2009
1/8/2009

then in B1 enter:
=SMALL(A:A,ROW()) and copy down and format as dates to see:

12/22/2008
12/24/2008
12/25/2008
12/27/2008
12/30/2008
12/31/2008
1/2/2009
1/3/2009
1/4/2009
1/5/2009
1/6/2009
1/7/2009
1/8/2009
1/9/2009


--
Gary''s Student - gsnu200822


"scott" wrote:

I have a sheet that records daily test results for one month. On any given
day there can be 1-10 entrees. Currently I have a column that we put an x in
and then I have macros recorded to sort and put them in order acording to
date. My problem is my version of excel is old enough I can not password
protect this page because I then get errors during the sort. From what I have
read I need a newer version of Excel and all the VB code I have found does
not work with my current version. My company has decided not to purchase a
newer version as of yet. I was wondering if there is a formula that I can
use to put the chosen dates in order with out using a macro. When these test
are run and recorded I only need one of the results entered in the daily
report form. Since I have formulas on this ss I and I can not protect it
employees are starting to change formulas so I need this passworded.
Thanks Scott

Need a formula to sort without using a macro
 

Ok I see what that does but that is not really what I am trying to get. Say a
complete set of test are run on 12-1-08. Another set of the same test are run
on the same day. Only one of these results needs to be recorded on a seperate
report form. I was using the X to distinguish which set of test are recorded.
One months of test are on the ss but only one test result from each day needs
to go to the monthly report which is adifferent ss. I used the macros to sort
the results.

"Gary''s Student" wrote:

You don't need a macro to sort dates. For example, If in A1 thru A14 we have:

1/9/2009
1/4/2009
12/25/2008
12/27/2008
12/24/2008
1/3/2009
12/31/2008
1/7/2009
1/2/2009
12/30/2008
1/5/2009
12/22/2008
1/6/2009
1/8/2009

then in B1 enter:
=SMALL(A:A,ROW()) and copy down and format as dates to see:

12/22/2008
12/24/2008
12/25/2008
12/27/2008
12/30/2008
12/31/2008
1/2/2009
1/3/2009
1/4/2009
1/5/2009
1/6/2009
1/7/2009
1/8/2009
1/9/2009


--
Gary''s Student - gsnu200822


"scott" wrote:

I have a sheet that records daily test results for one month. On any given
day there can be 1-10 entrees. Currently I have a column that we put an x in
and then I have macros recorded to sort and put them in order acording to
date. My problem is my version of excel is old enough I can not password
protect this page because I then get errors during the sort. From what I have
read I need a newer version of Excel and all the VB code I have found does
not work with my current version. My company has decided not to purchase a
newer version as of yet. I was wondering if there is a formula that I can
use to put the chosen dates in order with out using a macro. When these test
are run and recorded I only need one of the results entered in the daily
report form. Since I have formulas on this ss I and I can not protect it
employees are starting to change formulas so I need this passworded.
Thanks Scott

Need a formula to sort without using a macro
 

Hello Scott,

You can sort automatically with Worksheet functions only into a copy
area:
http://www.sulprobil.com/html/sorting.html

Regards,
Bernd