hello!
I have a couple of questions here..
I have 14 files with information bout companies, each file should loo
like this:
.......................company 1............................... compan
2.........etc
...........2002 2001 2000 1999 1998..........2001 2000 1999
ratio1
ratio2
ratio3
So it means that a company can have information about 5 years or abou
4 or 2 or, depends what is available.
Each file has between 1 and 23 (I think) companies, so it can be a fil
with 2, another with 8 etc.
Each file is a group of companies grouped according to certain ratings
A, B, C, D...
So far I have made for each file/rating the average, quartil 25%
quartil 75% and median sorted per years. So the macro looks first i
the line with the year, if it is 2002, then sums up the values an
divides for the nr of values, and so on for each year. For the media
quartils it puts the info in an array to then sort it from small to bi
etc.
NOW the problem gets complicated. I have to make an average, median an
quartils of ALL the information all together, forgetting about th
years, I cannot put all the companies in a sheet cuz it's not bi
enough...
So what I thought is to first put all the information in ONE file, on
file/rating per sheet. Then for each ratio (ratio1, ratio2..) / lin
look for ALL the columns that have information in ALL the sheets, s
first puts in an array the information in the sheet1, then in th
sheet2 etc and in the end sorts this array + calculates the median
quartils.. but I am not sure how to write this. Anybody has any idea?
then, will the array be too long (14 sheets, each sheet bout 1
companies average, each 4 years average, this would be bout 14*15*4,5
.. bout 950-1000 values)? do you think there's another way of doing it
Like making an array of each sheet and then putting the array
together, but then I am not sure how, would this work?
arraysheet1 (i.e = 212, 32, 43, 98, 1212, 328)
arraysheet2 (ie = 98, 74, 56, 122, 45)
...
arraytotal = arraysheet1+arraysheet2.... (so 212, 32, 43, 98, 1212
328, 98, 74, 56, 122, 45.....)
I haven't tried yet, been busy with the other stuff so far, thought o
asking for help and ideas here first.
Thanks a lot!!!
-----------------------------------------------
~~ Message posted from
http://www.ExcelTip.com
~~View and post usenet messages directly from
http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements