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