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
Bookmarks