money

  1. M

    Date specific bank balance running total

    Hi guys, Someone on here will probably find this dead easy. I want to set up a spreadsheet, that will tell me how much money I will still have before I get paid again. Basically, it would show the current date and I would input the dates and amounts of when money comes out of my bank. So, for...
  2. C

    I am totally stuck.

    I have a column range(V:V) of cells containing multiple entries separated by a comma (,). I have another column (AD) containing single entries. I would like to find a formula not VBA that counts all instances of a string (like "Make more money") in range V:V happening for one certain instance...
  3. A

    Split or Distribute Bill Between Friends With Formula

    James, Roy, Rich, Charles, Julie, Alice, Hector, Vinton, Kiera, and Corey are travelling. They are staying at a flat at 33 USD per day. They all have money but not equal and they are going to pay in sequence as mentioned in column. If someone don't have enough money the next person is going...
  4. B

    Excel Budget Planning Tips Please

    Hello, I am new to Excel and trying to make a budget planner. I have already created a basic sheet for the entire current month, a second sheet for Payday, and a third sheet for the following month. I have learned a lot of what not to do LOL :laugh:. Any tips or pointers out there to enhance or...
  5. G

    Complex Formula Question - Conditional Sums

    Hi guys I have a formula question I’ve been working on for a few days now and can’t seem to get my head round it, was hoping for some help. I basically have 4 customers, and we have invoices/credits due in 6 time buckets 1D though to 90+D. If at a total level I owe the customer money I pay...
  6. R

    Help subtracting expenses

    Hello i need some help with a table, it goes like this: I need to show me on A, how much money have left when the filtered data from C, the max allowed money is on E. Sorry for bad english. The sheet is annexed. For example, if i filter "Publicidade" on C, it show me on B all the money i...
  7. A

    Need a formula

    Hi Excel Experts, I have list of 50,000 people, they have different amount of money in their account. There is a required amount of money which always vary. I want a formula by which I will enter only required amount and can find the person who has equal or more amount than required amount...
  8. G

    PGA Tour Excel Spreadsheet with money list and FedEx Cup

    Hi all, I've been doing some research as to summing values from multiple sheets, but I haven't found an effective way to do what's in the title. Basically I plan to import player leaderboards from each tournament into separate sheets, including money winnings and FedEx cup points. I play the...
  9. T

    Generate a list from single cell input

    Hello, ive been tryin to figure out how to do the next thing. I am creating a tool for my workers where there could be a single cell where they enter the amount they spend and in the next cell they select from a drop down list the type of expense (transport, food, hotel, airplane, etc...) click...
  10. A

    Variable for rolling cash flow table?

    Hi all, I came to the conclusion I was never going to work this out on my own, despite reading and experimenting. Here's what I'm trying to do. I'm creating a spreadsheet which will show me cash available on any given day and for days in the future, based on predicted income and expenditure...
  11. L

    Multiple options

    I am trying to make excel give me an amount on a different cell, of a number that I have. For example: My added matched lottery numbers add up to 7 in some cases, 8 in others and so on. I want the cell to its right to tell what the count 11 is. Let me clarify better. The lower counts are...
  12. M

    Excel Hourly Wage Calculator

    I'd like to know of any way to make a counter in excel which keeps track of the time passed and can tell you much you have made based on an hourly wage you input. So far I have a timer that uses VBA and command buttons which I found online which simply counts upwards as time passes and records...
  13. E

    How much money could I ask to write a VBA routine that make a company make lots of money?

    Hello! I am an engineer. although my field is not properly the Informatics, I am pretty good in programming with Excel VBA. In the past I worked in a little company, where I developed a macro that made the company save a big amount of time and money (my macro did in 2 minutes what a person...
  14. T

    How can I make budgeting easier?

    So I have a new job and am trying to examine my expenses in excel (i.e. to budget), and I would like to find a way to automatically populate rows that will serve the purpose of not only dividing each week separately but also to calculate--inside one of the cells within the row--the week's total...
  15. D

    Moving 'Total' Rows Below a List of Costs Needed

    Ok, so at the moment I am trying my best to manage my money. As a student, I have to be very tight with money (which I haven't been so far). Anyway, today I decided I'd best start making a list of what money is coming in and out until (as I'm a student in England, I get student loans but I...
  16. S

    Separate the amount of money to small unit.

    Good morning. I have a problem about how to separate the amount of money into the small unit like -------money-3500-2751-2751-3500-4211- Type-1000------3----2----2-------3-----4--- Type-500-------1----------1-------1--------- Type-100-------2----------7-------------2---...
  17. A

    money/date calculation

    Can anybody help me with this formula for subtracting date/money?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> It seems easy but it’s a mind cruncher!!! <o:p></o:p> A1 - 64.0$ (expenses per day,number is changing its not constant) <o:p></o:p>...
  18. A

    Financial countdown timer

    Hi everyone, <o:p></o:p> I really need your help. For 1 month now I’m trying to make financial countdown timer – but no luck. <o:p></o:p> What I managed to do is how much money I have now and my (expenses) average money spent; - per day - per month, and - per year <o:p></o:p> <o:p></o:p> And...
  19. P

    Calculate expected return

    I need a formula for the following: Year 1 I want to save 500$. Year 2 I want to increase this saving with 10% Year 3 I want to increase this saving with 9% Year 4 I want to increase this saving with 8% Year 5 I want to increase this saving with 7% Year 6 I want to increase this saving...
  20. T

    Week Number

    I have an excel sheet for paychecks for total hours and i use the weeknumber function to total up paychecks that i should be getting and compare with actual, however the weeknum function that i use i can only get to start on monday or sunday, but i need the week to start over on friday how do i...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top