How to sort cells by dates when some cells are links to other cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

akm - 20 Apr 2008 03:31 GMT

When try to sort by date column, with some cells having dates created by
reference/link to anther cell not in the same column, the sorted cell/s
changes to a reference error (guess thats what Id call it, not sure what the
official name is) =#REF!
Any idea how to sort referenced date cells without getting that error ?
Thank you for your help.
akm

Reply to this Message

Shane Devenshire - 20 Apr 2008 17:03 GMT

Hi,

Make the date reference absolute: =$A$10

Cheers,
Shane Devenshire
Microsoft Excel MVP

> When try to sort by date column, with some cells having dates created by
> reference/link to anther cell not in the same column, the sorted cell/s
[quoted text clipped - 4 lines]
> Thank you for your help.
> akm

Reply to this Message

Héctor Miguel - 21 Apr 2008 05:51 GMT

hi, !

> When try to sort by date column, with some cells having dates created by reference/link to anther cell not in the same column
> the sorted cell/s changes to a reference error (guess thats what Id call it, not sure what the official name is) =#REF!
> Any idea how to sort referenced date cells without getting that error ?
> Thank you for your help.

AFAIK sorting data is the same as (re)write/type/enter/edit each of the sorted range cells's content so,
referenced/linked formulae to "the cell" (even in absolute notation) "retains" the cell address (BUT)...
what "changed" (in "the cell") is the content (of "the cell") :-((

I guess you *must* find another way to *anchor* (follow/index/find/...)
-> NOT "the cell" (address)... but "the contents" (of "the cell") -?-

hth,
hector.

Reply to this Message

Rate this thread: