Sorting data
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?? |
Sorting data
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" wrote: 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?? |
Sorting data
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. "Eduardo" wrote: 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" wrote: 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?? |
All times are GMT +1. The time now is 10:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com