--- In [email protected], "Gordon Sutherland" <[EMAIL PROTECTED]> wrote: > > Check-out the function: > > SetSortColumns( col1, col2, .... ) > > Cheers, > > Gordon Sutherland
Hi Gordon, That is a good solution for multi column sorting but I really am looking to rank each industry group based on various time frames. Here is an excerpt from an Automatic Analysis that I had to change to vertical in order to properly show it in this posting: Ticker MG851 Date/Time 6/22/2007 Name Internet Service Providers Close 24.2 1P % -0.4 1P R 38 I inserted this 1 Day change rank 5P % 0.3 21P % 2 Want to add 5 day, 21 day, 63 day and 255 day Ranks 63P % 35 255P % 116 NL 21 No ATR5 0.39 ADR5 0.39 HC 732.34 L YR C 13.78 YTD % 75.6 YTD R 1 Another row I inserted to show YTD Rank So all I am trying to do is rank each of the percentage change columns from 1 to 240 (best to worst) in this one AA report. Any help would be appreciated. Regards, Dave
