View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
 
Posts: n/a
Default Moving Cell Reference after Sorting

unfortunately using a constant there wouldn't work. if i needed to
change that data point and then re-sort it, i'd like the equation to
still refer to the data in that cell (wherever it moves after it's
sorted)