Re: Sort by two variables at the same time

Tech-Archive recommends: Fix windows errors by optimizing your registry

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 news:4B8C415E-D1C7-468D-A1F8-DB9599569804@xxxxxxxxxxxxxxxx
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






.

Relevant Pages

  • Re: Sort by two variables at the same time
    ... Can you provide the first five or six rows as they will be AFTER the sort ... (only the Beta and MV cols) ... If you find this post helpful pl. ... Sorting them seperately does not necessarily achieve ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Sort by two variables at the same time
    ... That does not make sense if MV and Beta are related... ... If not then you can sort both columns separately... ... I need highest MV and highest Beta both at the same time ... Mark ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Need info - Hybrid Squash, King Ka Ae F1 possibly known as Korean Pumpkin
    ... at least some of the information one the back of the packet doesn't ... "Beta bulgaris" a common typo for Beta vulgaris and the ... chart seem be more appropriate for beets than any sort of squash as well. ... "No dear, this is the dream, you're still in the cell." ...
    (rec.gardens)
  • Re: Sort by two variables at the same time
    ... You can instruct Excel to sort the data in a worksheet. ... Under Custom Lists, verify that NEW LIST is highlighted. ... If you find this post helpful pl. ... (only the Beta and MV cols) ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Sort by two variables at the same time
    ... So I can't give the first rows after the sort. ... (only the Beta and MV cols) ... I need highest MV and highest Beta both at the same time ...
    (microsoft.public.excel.worksheet.functions)