I have a "source data" worksheet and a "summary" sheet. The summary
sheet contains If Formulas referencing the source data sheet. Ex:
=IF(Sheet1!A1="","",Sheet1!A1). The problem is that when I sort the
data on the summary sheet, it sorts by the formula contained within the
cell. Is there a way to force it to sort based on value instead?