Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to simplify this process?
i have data in the form
mth n(day of yr) year dataA dataB dataC ..... dataN 1 24 94 .. .. .. .. 1 10 97 .. .. .. .. the data is from 1jan 92 to 31dec 98, and i have sorted in order of month. the purpose is to obtain the highest dataC value for jan92 , jan93, ... jan98 and output the month, n(day of yr) and year, probably in another sheet. Similarly, this is done for feb92 to feb98, and for the rest of the months. After this is done, this process is repeated for highest value of dataD, and dataE, and so on, up to dataN. Currently, i am manually sorting dataC in descending order and looking for the highest value for each month from 92 to 98, and doing dataD now. As there is over 2000 rows of data, how can i write a VBA program to automate this process? Thanks in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to simplify this process?
Oh, there's a problem...i am new to programming and couldn't understand what
you just typed. "Don Guillett" wrote: use this ARRAY formula which must be entered with control+shift+enter, where dates are in checksA range and checksD has the amount. Change to your ranges. If you name, you can use easily from the other sheet. Use a self adjusting (defined )name by insertnamedefinename it in the refers to box something like =offset($a$1,0,0,counta($A:$a),1) =MAX(IF(MONTH(ChecksA)=3,ChecksD)) -- Don Guillett SalesAid Software "KiriumF1" wrote in message ... i have data in the form mth n(day of yr) year dataA dataB dataC ..... dataN 1 24 94 .. .. .. .. 1 10 97 .. .. .. .. the data is from 1jan 92 to 31dec 98, and i have sorted in order of month. the purpose is to obtain the highest dataC value for jan92 , jan93, ... jan98 and output the month, n(day of yr) and year, probably in another sheet. Similarly, this is done for feb92 to feb98, and for the rest of the months. After this is done, this process is repeated for highest value of dataD, and dataE, and so on, up to dataN. Currently, i am manually sorting dataC in descending order and looking for the highest value for each month from 92 to 98, and doing dataD now. As there is over 2000 rows of data, how can i write a VBA program to automate this process? Thanks in advance! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to simplify this process?
Could you show me a short example for me to kick start with? Thanks!
"Don Guillett" wrote: use this ARRAY formula which must be entered with control+shift+enter, where dates are in checksA range and checksD has the amount. Change to your ranges. If you name, you can use easily from the other sheet. Use a self adjusting (defined )name by insertnamedefinename it in the refers to box something like =offset($a$1,0,0,counta($A:$a),1) =MAX(IF(MONTH(ChecksA)=3,ChecksD)) -- Don Guillett SalesAid Software "KiriumF1" wrote in message ... i have data in the form mth n(day of yr) year dataA dataB dataC ..... dataN 1 24 94 .. .. .. .. 1 10 97 .. .. .. .. the data is from 1jan 92 to 31dec 98, and i have sorted in order of month. the purpose is to obtain the highest dataC value for jan92 , jan93, ... jan98 and output the month, n(day of yr) and year, probably in another sheet. Similarly, this is done for feb92 to feb98, and for the rest of the months. After this is done, this process is repeated for highest value of dataD, and dataE, and so on, up to dataN. Currently, i am manually sorting dataC in descending order and looking for the highest value for each month from 92 to 98, and doing dataD now. As there is over 2000 rows of data, how can i write a VBA program to automate this process? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to simplify this... | Excel Worksheet Functions | |||
Simplify Process with Excel 2003 | New Users to Excel | |||
please help simplify | Excel Programming | |||
please help simplify | Excel Programming | |||
Simplify | Excel Programming |