+ Reply to Thread
Results 1 to 2 of 2

Organise multiple columns numerically

  1. #1
    Forum Contributor
    Join Date
    08-17-2009
    Location
    West Midlands
    MS-Off Ver
    Excel 2016
    Posts
    213

    Organise multiple columns numerically

    Hi

    I have data in the following format over 200 columns:

    Product 1 Product 2 Product 3 Product 4 Product 5
    Customer 1 4 0 0 8 1
    Customer 2 5 0 0 7 1
    Customer 3 9 0 0 4 2
    Customer 4 4 1 0 1 3
    Customer 5 1 4 0 1 0
    Customer 6 1 4 1 4 3
    Customer 7 2 0 0 8 2
    Customer 8 0 7 0 3 1

    Total 26 16 1 36 13

    I'd like to be able to sort these columns so that the largest value product appears on the left descending to the right.

    Is this possible?

    Thanks

    Steve
    Last edited by SAsplin; 10-24-2011 at 11:30 AM.

  2. #2
    Forum Contributor
    Join Date
    08-17-2009
    Location
    West Midlands
    MS-Off Ver
    Excel 2016
    Posts
    213

    Re: Organise multiple columns numerically

    Don't Worry - I've worked it out!!

    Thanks

    Steve

+ 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