Results 1 to 9 of 9

Cannot sort calculations in tables....

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2014
    Location
    Nashville, TN
    MS-Off Ver
    365
    Posts
    33

    Cannot sort calculations in tables....

    Guys; See the attached file, which includes three tabs, each of which has a table with a number next to an entry that is colored.

    What I'm trying to do on the third tab, titled "calculations," is just subtract the number from the middle tab (data 2) from the number in the first tab in that same row (data 1), do this for every number in the table, and have the results show in the table. This part is already done.

    Here is the problem: I can't get the "calculations" table to sort...I need to sort those results by the numbers from least to greatest. It seems to be sorting randomly.

    Not sure what the issue could be. Would appreciate any help. Thanks alot.
    Attached Files Attached Files
    Last edited by pshearer; 01-13-2016 at 09:22 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculations in Word Tables?
    By MKR in forum Word Formatting & General
    Replies: 2
    Last Post: 03-21-2013, 10:39 AM
  2. Displaying Values in Pivot Tables instead of Calculations
    By casrol in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2012, 08:37 PM
  3. Calculations within Pivot Tables
    By Datech in forum Excel General
    Replies: 4
    Last Post: 03-19-2012, 03:05 PM
  4. Calculations in Pivot Tables
    By mcooper1975 in forum Excel General
    Replies: 3
    Last Post: 06-09-2011, 04:13 PM
  5. tables, references, calculations
    By Poposhka in forum Excel General
    Replies: 6
    Last Post: 05-25-2010, 05:08 PM
  6. Pivot Tables-Calculations?
    By CrimsonPlague29 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2006, 10:55 AM
  7. [SOLVED] Calculations in pivot tables
    By Kathy P in forum Excel General
    Replies: 0
    Last Post: 04-06-2006, 07:15 PM
  8. Calculations that Refer to Pivot Tables
    By BillM in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2005, 10:29 AM

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