Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro sort | New Users to Excel | |||
Ascending Sort formula, change to neg #: descending sort.. | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Using Macro to sort without clicking on macro button | Excel Discussion (Misc queries) | |||
Sort Macro | Excel Discussion (Misc queries) |