(Msg. 1) Posted: Sun Nov 16, 2008 2:30 pm
Post subject: Sorting data Archived from groups: microsoft>public>excel>misc (more info?)
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??
(Msg. 2) Posted: Mon Nov 17, 2008 9:01 am
Post subject: RE: Sorting data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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??
(Msg. 3) Posted: Tue Nov 18, 2008 2:04 pm
Post subject: RE: Sorting data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office