Extrapolating A Top Ten
Jul 29, 2009
Every month I use a worksheet that has the following information:
Countries Amount
argentina $5
brazil 10
chile 13
china 54
denmark 8
Finland 23
France 15
India 23
Indonesia 4
Japan 3
Russia 68
south africe 39
The list is actually a lot longer but is there a formula to allow me to extrapilate the top ten amounts without using a macro to sort and filter?
View 3 Replies
Dec 15, 2009
I have several thousand cells where I need to pull out some information at the end of each cell. So for the examples listed below, all the information resides in the "A" column. For example:
M55116/14-5 CONN,RECEPT,6 PIN,U-228 TYPE B EA A AS 17 85.00 1,445.00
M39029/30-222 CONTACT,#0,RED-RED-RED B EA A AS 96-0327 46 6.75 310.50
M39029/44-288 CONTACT B EA A AS 93-0852 400 2.18 872.00
I am trying to pull off (starting from the end) all of the information to the first space. So I would like the following results returned: 1,445.00, 310.50, and 872.00. Can anyone recommend if there is a Function or equation that I could use that would pull everything from the end of the cell until the first space?
View 4 Replies
View Related
Sep 27, 2007
I have a spreadsheet that holds a list of customers and the contracts they have with my company - this sheet includes the Total Contract Value in £s - so how much each customer will pay us for the service - the period of the service - so the start date of 01/01/08 to end date of 31/12/08 for example. What I then have is all the months across the top of my spreadsheet and I need to extrapolate the contract value, based on the period between the months.
Initially I had complicated formulas that simply divide the value by the number of months of the contract - however, my company has since changed the policy and requires it to be done to the day.
For example, if the value was £12,000 and the period was 12 months from 01/01/08 - to calculate January 08 it would be - 12,000 / 365 * 31, Feb would be 12,000 / 365 * 29 and so on...
Does anyone know how I can do this - bearing in mind that each contract won't be as easy as 12 months - it may be start date of 15/06/08 to 08/10/10 for example... If anyone can help me do a formula or formulae to calculate the value for each month - I would be very very grateful - as always... [/img]
View 9 Replies
View Related
Sep 24, 2008
From four known set values at the four corners of a table, how can I fill in the values in between? I.E. the inverse of extrapolating. I have a program within a programme that will do this, so i know its possible, but ideally i would like to be able to do it straight into a spreadsheet.
View 3 Replies
View Related
