+ Reply to Thread
Results 1 to 2 of 2

How to sort collumns?

  1. #1
    Registered User
    Join Date
    05-22-2016
    Location
    polska
    MS-Off Ver
    office 2010
    Posts
    1

    How to sort collumns?

    Hello. I need to build a table chart for food. It requires to have couple columns and lines in order to store informations. Name of the fruit, its weight, nutriens for whole fruit, nutriens for certain weight, money cost of while fruit, cost of certain weight etc. And i need ability to sort it so i can have them set from the most expensive to the least one if i click price and the most nutrieus to he least if i click nutriens. That way i can estimate what is most efficient and valueable according to cost or mass.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.96 for Mac MS 365
    Posts
    8,690

    Re: How to sort collumns?

    build your information in a sheet and across the top apply filters to row 1 where the titles are (price, nutrients, etc.) Then you can sort them by the price or by the nutrients.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : Unlocking Collumns
    By stuart3 in forum Excel General
    Replies: 5
    Last Post: 11-05-2011, 03:53 AM
  2. Loop to run through collumns
    By Glytch in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-18-2008, 10:16 AM
  3. Collumns to text
    By trafficbroker in forum Excel General
    Replies: 4
    Last Post: 09-07-2006, 10:10 AM
  4. Sub Total collumns
    By Darren via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2006, 07:00 PM
  5. Totalling Collumns
    By Stormingerman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2005, 09:50 PM
  6. [SOLVED] Collumns and rows
    By smintey in forum Excel General
    Replies: 3
    Last Post: 02-15-2005, 02:06 PM

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