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

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

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

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

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

OK.

In the meantime...

You can
try combining the two columns into a helper column (=A1&B1)
making a custom list in the order you want and then sort using the custom list
___________________
You can instruct Excel to sort the data in a worksheet. If the sorting
orders within Excel do not meet your requirements, you can create your own
sorting order. For example, if you type in Red, Green, Blue, and Black, Excel
would normally sort them in alphabetical order. However, if you do not want
them sorted this way, you can create your own custom sort order by completing
the steps listed below:

1. Within Excel, click Tools and click Options.
2. Select the Custom Lists tab.
3. Under Custom Lists, verify that NEW LIST is highlighted.
4. In the List Entries field, start typing in your list elements in the
order they should be sorted. Make sure you press Enter after each element.
5. Once you have typed in all the elements, press Add.
6. Click OK.

You can now use the special sort order to sort your data. Select the cells
that contain the data you want to sort. From the Data menu, click Sort.
Select the Options button. Use the drop down arrow to select the sort order
you created in the previous steps. Click OK. Click OK to close the Options
dialog box.
___________________

--
If you find this post helpful pl. choose "Yes"...


"MS" wrote:

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

Hello Sheeloo

Sorry, if I could sort at the same time, I would not need to leave a message
here. So I can't give the first rows after the sort.

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

Did you see my last post (copied below)....

I don't want the actual row, just how it will look if you are able to sort..

--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"MS" wrote:

Hello Sheeloo

Sorry, if I could sort at the same time, I would not need to leave a message
here. So I can't give the first rows after the sort.

Mark