+ Reply to Thread
Results 1 to 3 of 3

Sort by the multiple of 2 columns without making another column?

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    Norwalk, CT
    MS-Off Ver
    Excel 2010
    Posts
    80

    Sort by the multiple of 2 columns without making another column?

    Hi,

    I have two columns A and B. Is it possible to sort by the product of the two columns without making a third column C? Something like this...


    Please Login or Register  to view this content.
    Thanks,
    Nick

  2. #2
    Forum Contributor
    Join Date
    02-07-2012
    Location
    MIA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    429

    Re: Sort by the multiple of 2 columns without making another column?

    I don't think that's possible... Why can't you use an auxiliary column?
    .*)
    `..*).*)
    (. (.
    Pichingualas <---
    ﰯﰯﰯ

    Wrap your code with CODE TAGS.
    Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
    Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).

  3. #3
    Registered User
    Join Date
    05-18-2012
    Location
    Norwalk, CT
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Sort by the multiple of 2 columns without making another column?

    Quote Originally Posted by Pichingualas View Post
    I don't think that's possible... Why can't you use an auxiliary column?
    Laziness, resolving

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1