Posts by resssc10

• Formulas : help i&#039;m stuck!!

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?

• Formulas : help i&#039;m stuck!!

FANTASTIC, IT WORKS LIKE A DREAM NOW.
THANKS A LOT

• Formulas : help i&#039;m stuck!!

don;t mean to sound daft, but how do i change to an absolute reference from a relative reference?
Thanks

• Formulas : help i&#039;m stuck!!

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

• Formulas : help i&#039;m stuck!!

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

• Formulas : help i&#039;m stuck!!

none, except for the fact that i'm an idiot!!
thanks for your help - much appreicated

• Formulas : help i&#039;m stuck!!

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

• Formulas : help i&#039;m stuck!!

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