Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data | Excel Worksheet Functions | |||
Sorting data to match existing data | Excel Discussion (Misc queries) | |||
Need help sorting data | Excel Discussion (Misc queries) | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
Need help Sorting data | Excel Worksheet Functions |