Results 1 to 4 of 4

Excel 2007 : Extracting Largest Variances

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2011
    Location
    Addlestone, Surrey, UK
    MS-Off Ver
    Excel 2007
    Posts
    17

    Extracting Largest Variances

    On the attached spreadsheet I have encountered a problem that I am struggling to resolve. In cells G4 and G14 I have variances of 585,000 & (585,000). In column W I am ranking the largest variances regardless if the variance is positive or negative. In cells W6 & W7 the formula is referencing both cells to cell G4 instead of one delivering the value from G4 and the other giving the value of G14

    Any help would be gratefully appreciated !!

    Many thanks

    Mike
    Attached Files Attached Files

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