+ Reply to Thread
Results 1 to 12 of 12

Sort between bold rows with value of largest to smallest in the fourth column

  1. 05-07-2013, 09:39 PM #1
    minks
    minks is offline
    Registered User
    Join Date
    05-07-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Sort between bold rows with value of largest to smallest in the fourth column

    [table="width: 500, align: center"]
    [tr]
    [td]Underlying Holdings [/td]
    [td]Column2 [/td]
    [td] Column 3 [/td]
    [td]Market Value[/td]
    [/tr]
    [tr]
    [td]Asset 1[/td]
    [td]Number [/td]
    [td]Number 2[/td]
    [td]Asset Market Value[/td]
    [/tr]
    [tr]
    [td]Sub Holding 1[/td]
    [td][/td]
    [td][/td]
    [td]Sub Asset Market value[/td]
    [/tr]
    [tr]
    [td]Sub Holding 2[/td]
    [td][/td]
    [td][/td]
    [td]Sub Asset Market Value[/td]
    [/tr]
    [tr]
    [td]Asset 2[/td]
    [td]Number [/td]
    [td]Number 2 [/td]
    [td]Asset Market Value[/td]
    [/tr]

    Hi,

    I have a spreadsheet in which I want to use only the first 4 columns and taking into account the values in the fourth column, I want to sort the four columns from largest to smallest based on the sub asset market values.
    Attached Files Attached Files
    Last edited by minks; 05-07-2013 at 11:52 PM. Reason: Messed up the first time
    Reply With QuoteRegister To Reply
  2. 05-07-2013, 11:44 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Sort between bold rows with value of largest to smallest in the fourth column

    Hello minks,

    Welcome to the Forum!

    Your post is a little difficult to understand since you post is in raw HTML. The HTML code tags are not tuned on for your account.

    If you can post your workbook with before and after examples, it will be easier to provide you with a solution.

    To Post Your Workbook
    1. At the bottom right of the Reply window, Click the button Go Advanced
    2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
    3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
    4. Click the Select Files button at the bottom middle of the dialog.
    5. In the new window Find the file you want to upload, select it, and Click Open.
    6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
    7. Wait until the file has completely uploaded before you exit the File Manager dialog.

    File Manger Picture
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 05-07-2013, 11:52 PM #3
    minks
    minks is offline
    Registered User
    Join Date
    05-07-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Sort between bold rows with value of largest to smallest in the fourth column

    Thank you very much! I just attached an example file.
    Reply With QuoteRegister To Reply
  4. 05-08-2013, 12:30 AM #4
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Sort between bold rows with value of largest to smallest in the fourth column

    Hello minks,

    I think the easiest method is to use the AutoFilter. I have turned it on in the attached wprkbook for you you can select filter for column "D" and click on Sort Z to A (largest to smallest). If you need something more than this, let me know.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 05-08-2013, 01:00 AM #5
    minks
    minks is offline
    Registered User
    Join Date
    05-07-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Sort between bold rows with value of largest to smallest in the fourth column

    I'm actually trying to sort based on the non-bolded values in the fourth column. Each sub asset market value needs to be sorted from largest to smallest for a personal asset. Furthermore, I have to do this for multiple amounts of spreadsheets everyday and need to be able to explain it to others so I'm trying to find assistance with the use of a macro to do so. Would you be able to help?
    Reply With QuoteRegister To Reply
  6. 05-08-2013, 01:29 AM #6
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Sort between bold rows with value of largest to smallest in the fourth column

    Hi minks,
    maybe so
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 05-08-2013, 01:36 AM #7
    minks
    minks is offline
    Registered User
    Join Date
    05-07-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Sort between bold rows with value of largest to smallest in the fourth column

    WIll this work even if there are filled cells in the columns to the right? I only wanted 4 columns to be sorted. Thank you so much! You're fantastic
    Reply With QuoteRegister To Reply
  8. 05-08-2013, 01:54 AM #8
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Sort between bold rows with value of largest to smallest in the fourth column

    With Cells(j, 1).Resize(i - j, 4) - this means that the range sorted consisting of 4 columns
    .Sort Key1:=.Cells(1), Order1:=xlDescending - but sorting is conducted by the first column
    Reply With QuoteRegister To Reply
  9. 05-08-2013, 02:07 AM #9
    minks
    minks is offline
    Registered User
    Join Date
    05-07-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Sort between bold rows with value of largest to smallest in the fourth column

    It doesn't seem to work. I am attaching the file that I tested it out on.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 05-08-2013, 02:52 AM #10
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Sort between bold rows with value of largest to smallest in the fourth column

    the other option (all 4 columns are sorted)
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 06-07-2013, 06:15 PM #11
    minks
    minks is offline
    Registered User
    Join Date
    05-07-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Sort between bold rows with value of largest to smallest in the fourth column

    I'm an idiot. It works. The only problem is that my rows which i thought were bold are actually black relative to grey. So all I'm working now right now is turning those black rows into bold.
    Last edited by minks; 06-07-2013 at 06:47 PM.
    Reply With QuoteRegister To Reply
  12. 06-07-2013, 06:27 PM #12
    minks
    minks is offline
    Registered User
    Join Date
    05-07-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Sort between bold rows with value of largest to smallest in the fourth column

    Reference above
    Last edited by minks; 06-07-2013 at 06:47 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1