Sorting data

  • Thread starter Thread starter James
  • Start date Start date
J

James

I am tring to sort a list of data in two columns. The information is being
retreived by the formula =b5 etc. I can sort some iformation but then the
other fields dissappear. How can i rectify this??
 
Hi James if I don't missunderstood you have a formula that retrieve the data
from other cell. what is in the 2nd column and how is linked to the first one
 
Call me dumb but i sorted it eventually. It came in a flas of inspiration.
I had (lets say) two cloumns, one with names and one with a formulae to
return a value from earlier in the workbook. When i was sorting them to show
highest to lowest the second column was loosing it's data. To counteratct
this i just locked the formulae like this cell b =p$14 for example.
 
Back
Top