Hello Sheeloo

The files are 100 mb or more. And are very complex. But the fundamentals of
what I want is to ultimately be able to determine what sorting I want to
ably. I have daily observations of 3800 firms over 25 years. So finally I
need to be able to run the double sort about 9000 times.

But firstly, I need to be able to look at what I get when I run HH, MM, LL.
Then a combination of HM, HL, MH, ML, LH LM and so on. I plan to also test
other combinations such as simply HL, LH etc.

I'll see if I can cobble some data together and post it here as an example.

Thanks
Mark

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Dear MS,

Can you provide the first five or six rows as they will be AFTER the sort
is
done?
(only the Beta and MV cols)

I guess you want
H H
M M
L L

but what about H M, H L etc?
--
If you find this post helpful pl. choose "Yes"...

Can you email the file to me?

"MS" wrote:

Hi

I would not leave a message if it were that simple.

I need to sort by the two variables at the same time so that I have my
data
sorted by firms that have BOTH high MV and Beta, or medium MV and Beta or
low MV and Beta. Sorting them seperately does not necessarily achieve
this.

Mark


"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote
in
message ...
That does not make sense if MV and Beta are related...
If not then you can sort both columns separately...

Can you give a couple of sample values...?
--
If you find this post helpful pl. choose "Yes"...


"MS" wrote:

Hi

I need to sort by two variables at the same time.

I need highest MV and highest Beta both at the same time

Any ideas?

Mark