Sorting cells with formula links

R

Ron

My spreadsheet contains a "summary" sheet with cells linked to data from other files/sheets. The links are in formulas such a

='C:\MCP\[MCP002.xls]Record1!$C$

I would like to sort the "summary" sheet - not by the formula text value (which is what is happening), but by the value returned by the formula (the linked value). Specifically, some of the linked values are blanks - but those cells are being sorted to the top of the list instead of the bottom because the cells being sorted aren't blank (they contain the text formulas)

Once again, any help provided is greatly appreciated

Ro
 
T

Tom Ogilvy

Sort doesn't have options for what to sort on. You will have to adjust your
formulas to achieve the result you want.

--
Regards,
Tom Ogilvy

Ron said:
My spreadsheet contains a "summary" sheet with cells linked to data from
Click to expand...
other files/sheets. The links are in formulas such as
='C:\MCP\[MCP002.xls]Record1!$C$2

I would like to sort the "summary" sheet - not by the formula text value
Click to expand...
(which is what is happening), but by the value returned by the formula (the
linked value). Specifically, some of the linked values are blanks - but
those cells are being sorted to the top of the list instead of the bottom
because the cells being sorted aren't blank (they contain the text
formulas).
 
Top