Results 1 to 1 of 1

Thread: Effective way of calculating the difference

  1. #1
    Junior Member
    Join Date
    Dec 2012
    Posts
    3
    Rep Power
    0

    Lightbulb Effective way of calculating the difference

    Hi all, attached is my sample data. I am trying to find the difference of the values from day-to-day of every column e.g. E, F, E, F for the 4 days.
    Any effective way of doing what I am trying to achieve? highlighted yellow is what I have tried.

    This is just a small portion of sample data. Data I will be using will be a big big set =]
    Attached Files Attached Files

Similar Threads

  1. Calculating Subtotals Within Groups of Data Using UNION
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 1
    Last Post: 05-24-2013, 11:54 AM
  2. Calculating Ratio Within Groups using Self Join
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-21-2013, 07:52 PM
  3. Move or Copy Duplicate Rows to Difference Sheet
    By Vgabond in forum Excel Help
    Replies: 3
    Last Post: 12-08-2012, 12:33 PM
  4. Get time difference in excel using vba
    By LalitPandey87 in forum Excel Help
    Replies: 1
    Last Post: 10-09-2012, 07:57 AM
  5. Range Difference VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 03-21-2012, 05:58 PM

Posting Permissions

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