Sorting data

[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??

 

[Eduardo]

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

 

[James]

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.