Sorting cells with formula links
 

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

Sorting cells with formula links
 

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" wrote in message
...
My spreadsheet contains a "summary" sheet with cells linked to data from
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
(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.

Ron