FYI...This is resolved. The problem occurred because within my formula I
included the sheet name. Upon removing the sheet name from the formula the
sorting functioned properly.
Rob
On Tuesday, February 9, 2016 at 4:05:06 PM UTC-8, robf...@gmail.com wrote:
> I am working with Excel 2013 and am
I am working with Excel 2013 and am experiencing difficulty trying to sort
a block of data based on a '% share' calculation.
Each cell in the '% share' column is a formula; for example B9/$B$29
Where cells B9 through B28 are themselves a formula: (for example cell B9
is "=COUNTIFS(Year,Sel_Year
