View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Grace[_2_] Grace[_2_] is offline
external usenet poster
 
Posts: 8
Default cell formulas issue in sorting data

Is it possible to keep the cell's orginal formulas after it's been sorted?
E.g. if before sorting D3 = "D1", after sorting, D3 becomes to position of
"E4", is it possible to make the "E4" still eaqual to "D1"?
It sounds weird, right?
Many thanks in advance, please.

Grace