Hello,
back again!!
I've used the sort feature which works great, however, I need it to automatically put the list into order. Using the sort feature, at present i need to manually sort each time new figures are used.
Is there a way to organise this so that excel automatically puts the figures into asecending order, even when the figures change?
Thanks for your help
FANTASTIC, IT WORKS LIKE A DREAM NOW.
THANKS A LOT
thanks for your answers, i'll try these
don;t mean to sound daft, but how do i change to an absolute reference from a relative reference?
Thanks
yes, that's exactly what is happening, the values are based on other formulas elsewhere in the s/sheet. Is they any way around this or alternative methods i could use?
thanks
back again!!
I've tried to use data sort, but it doesn't work - I can only guess that it's something to do with the formulas in the cells which may be mucking up the sort?
Any ideas?
Thanks
none, except for the fact that i'm an idiot!!
thanks for your help - much appreicated
Thanks for your reply.
At present I have the two columns like this
Rate Amount
0.12 49250
0.00 49250
0.00 49550
0.00 0
0.00 0
My aim is to get the rate in order from the lowest - highest with the corresponding amount next to it.
I've got the rate from low to high using the small formula
so it looks like:
Rate
0.00
0.00
0.00
0.00
0.12
Now i've got to get the relevant amount next to each of these rates, so that it looks like this
Rate Amount
0.00 0
0.00 0
0.00 49250
0.00 49550
0.12 49250
is there any way of doing this?
many thanks
i'm working on a spreadsheet and am desperate to sort out the following problem.
two columns of numbers as follows:
Rate Amount
0.12 49250
0.00 49250
0.00 49550
0.00 0
0.00 0
I've got the rate in order from highest to lowest ie
Rate Amount
0.00 ?
0.00 ?
0.00 ?
0.00 ?
0.12 ?
Now need to get the amount next to each, so total amount in this case will be 148,050, split as above.
Numbers won't always be like this, eg sometimes will have each rate & amounts different, but needs to be able to cope with the above.
I've tried vlookup, but doesn't seem to work with the 0.00's having different amount values?
ANY help would be much appreciated,
Thanks
