Posted in: Software
Scott T asked:
any ideas cause im up for a bit of racing!
any ideas cause im up for a bit of racing!
3
Archive for the ‘Software’ Category
Posted in: Software
Scott T asked:
any ideas cause im up for a bit of racing!
any ideas cause im up for a bit of racing!
Posted in: Software
comb asked:
Ex: I have 1/4/2004 in one cell and 6/4/2009 in another. I want to write a formula that will tell me how many March’s there were between those dates. (or January’s, February’s, September’s, etc…)
Ex: I have 1/4/2004 in one cell and 6/4/2009 in another. I want to write a formula that will tell me how many March’s there were between those dates. (or January’s, February’s, September’s, etc…)
Posted in: Software
lkeiser8517 asked:
I have an excel document that contains several sheets specific to each account. Columns A (Deposits), C (Interest accrued for the month) & E (disbursements) contain dates while columns B, D, & F contain the amounts for each transaction. Column G contains the running total for each month B+D-F. I need a formula that can disperse the amount of interest accrued for the month between the different accounts/sheets assuming there is money in that account at the end of the month in which the interest was earned. For example I accrued $1,146.00 of interest for the month of January 2009. I need a formula to go in column D that divides the $1,146.00 among the different spreadsheets based on each account’s average daily balance on 01/31/2009.
I have an excel document that contains several sheets specific to each account. Columns A (Deposits), C (Interest accrued for the month) & E (disbursements) contain dates while columns B, D, & F contain the amounts for each transaction. Column G contains the running total for each month B+D-F. I need a formula that can disperse the amount of interest accrued for the month between the different accounts/sheets assuming there is money in that account at the end of the month in which the interest was earned. For example I accrued $1,146.00 of interest for the month of January 2009. I need a formula to go in column D that divides the $1,146.00 among the different spreadsheets based on each account’s average daily balance on 01/31/2009.
Thanks!
Posted in: Software
janedoe1981 asked:
Basically what I’m looking for is either a macro or formula to help me use data more efficiently in excel. In one instance, I am working off a receivables aging but rather than having it set up as you would normally think of it, I have the amount due in one column and then the number of days past due in a separate column. So I need to be able to count all of those items 30 days past due, 30-60 days past due, etc and I also need to be able to sum the items 30 days past due, etc. I typically use COUNT and SUMIF but I can’t get those to work when I need to say greater than 30 but less than 60 and greater than 60 but less than 90. I know I must be writing something incorrectly.
Basically what I’m looking for is either a macro or formula to help me use data more efficiently in excel. In one instance, I am working off a receivables aging but rather than having it set up as you would normally think of it, I have the amount due in one column and then the number of days past due in a separate column. So I need to be able to count all of those items 30 days past due, 30-60 days past due, etc and I also need to be able to sum the items 30 days past due, etc. I typically use COUNT and SUMIF but I can’t get those to work when I need to say greater than 30 but less than 60 and greater than 60 but less than 90. I know I must be writing something incorrectly.
I also have a spreadsheet where I have a column of dates and I need to know how to sort it into separate quarters. So I need a formula/macro that would look at each date and separate it into 1st quarter 2009, 2nd quarter 2009 and so on.
On another note, I have been thrown into a role at work where I’ll be doing all of this on a regular basis. I only know basic excel formulas so I could use a course on macros and formulas but I can’t seem to find a good one. I tried a community excel course but it was too basic for me. I looked at college courses but no one seems to offer an advanced excel course. Any ideas?
Sorry for being so long.