cash

  1. J

    Guidance: Data table setup for Dashboard (Pivot Charts) Output

    Hi, Looking for guidance to create a Dashboard for quanties of stock, cashflow and other KPIs. I have table of data where: Column A = Date (ordered, earliest to latest) Column B = "In" or "Out" (if it's stock received or stock dispatched) Column C = Product code (e.g. 1, 2, 3, 4, 5) Column D =...
  2. E

    Finding cash sales for specific cashier question

    Hello and thank you in advance for the help. How can I accomplish this with a formula. Here's the situation. In my spreadsheet column A shows the cashier ID and column C is supposed to show the cash sales for the cashier. Over to the right on the same spreadsheet column J shows the different...
  3. B

    Index/match multiple criteria, multiple results

    I need to review a list of data and return all of the matches based on 2 criteria and cannot figure out the entire formula. Below is what I have now but it only matches 1 criteria: "CASH IN IMPORT'!$R$5. How on earth do I add a second criteria, which would be column B of sheet '3.INT' matching...
  4. Mazbuka

    opying into cells if particular criteria is met

    I have an excel journal template that I want completed from a cashbook type source...I'll show a simple example: Say this is my cashbook <colgroup><col span="4"><col><col span="3"><col></colgroup><tbody> A B C D 1 DATE DETAIL AMOUNT CASH/CHECK 2 17-10-19 John 1000...
  5. N

    VLookUp ComboBox input to update TextBox values

    Hello, I have the code below to get the lookup amount of the selected client from sheet5, but I don't know what I did wrong since it's not showing the amount on the "txtTotal, can you please help me to get the amount of the selected client? Note: the Amounts on column "D" contains formulas...
  6. M

    Cash Counting sheet

    Hi Everyone I am pretty good at excel until it comes to layout.. I’m a Treasurer with a local soccer club and we have a snack shack that I am responsible for. I need to create a sheet where I can enter the total number of notes for each denomination but here is the tricky part I need to do it...
  7. J

    Help: SUMIF

    Dear excel brothers and sisters, need your help please on something that perhaps is simple problem :) 1) I have a cash flow that runs on periods: ROW 1 - PERIODS: 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / ROW 2 - CASH FL: 1 / 1 / 1 / 1 / 1/ 1 / 1 / 1 / 1/ ROW 3 - CELL: A3=5 2) My goal is to sum...
  8. S

    Allocating revenue cash blows on a straight line basis over a fixed period

    Hi, I have been given a task at work to allocate the revenue inflow from sales between a given start date and end date. The key known variables are: Start date End date Frequency of billing Total number of bills Amount per bill Total amount of cash flow during the period What would be the best...
  9. L

    Private Equity IRR Calc

    Hey All, Quick question, I'm trying to calculate an ongoing IRR calc for a Private Equity Investment. For every period, I want to have an IRR calc up to that point. I need to somehow bring in the Fair Value of the fund on that date into the last cash flow of the IRR calc, otherwise the Cash...
  10. I

    Excel Data Consolidation

    I am working on a salary sheet and stuck on this situation. Sheet has a to z columns with these headings. What i need is, if employee name and employee code repeat several times, then i get sum of his duty, wages, pf, esi, pt, gross salary, advance, uniform, add money, take home, bank cheque...
  11. M

    Looking for a way to distribute left over cash flows over other loans

    Hi, I'm looking for a way to distribute left over cash flows to other loan repayments. At the moment I have a percentage input of the free cash flows to be distributed over 5 different loans. Those free cash flows are annual and the percentages are fixed. At some point in time, 1 of those...
  12. L

    NPV without repetitive cash flows

    Hi, Is there any way get NPV of uneven cash flows, without listing all cash flows? I'm hoping to replicate the Financial Calculators CF function, for instance BA II plus has CF function. You don't have to list all cash flows, you just point out how many time each cash flow should be paid out...
  13. M

    Formula to identify / remove duplicates based on one column

    Hi I've got three groups of data over 9 rows. Each group has duplicates and I'd like to delete the duplicate rows based on data in column C, which has Cash Sales. In the table below, column A has Product IDs, column B has Product Names, column C has Cash Sales and column D has the Group...
  14. B

    SUMIF and VLookup/Index match for consolidating Data

    Hello, I'm trying to make life a little more efficient for some of our accountants but have hit an excel brick wall. Background: We consolidate about 7 company's financials into one consolidated financial statement. For reasons unknown, these financials are not in a standardized format so I...
  15. T

    Dynamic Text List, ignoring "0"

    I am making a weekly summary file for my bar. End of each week I "move or copy" the 7 daily cash up sheets into the weekly sheet, named by the days of the week. In the weekly sheet, I have the cash summary page, which has a column of various headers (denomination, pdq, amex, discrepancies, etc)...
  16. S

    2 Named Ranges - Same Name - Delete Only 1

    Hi All, I have inadvertently, through another piece of code, got a number of files that have 2 named ranges with the same name. I'd like to delete just one of these but not sure how i'd write the code to ensure I was deleting the correct one (the bottom of the 2 below): Name...
  17. F

    Expenses and Sales- Filter problem

    Hello guys, Please find attached an EXCEL I created for Daily Expenses / Outputs and Daily Sales/Inputs. (cant find attachment feature here) Unfortunately I can't use the FILTER properly. -If you try to filter BANK category to show only, it also includes Cash. -If you filter CASH category to...
  18. D

    How to solve for sell price based on inputting Cash on Cash Return percentage?

    Please refer to the attached spreadsheet, my property analyzer. You'll see all the columns on the left that show all the important metrics I look for when analyzing potential investment properties. After entering a minimum of data I look to the YEAR 1 COC ROI (COC) (Cash on Cash Return on...
  19. D

    Solving for sell price based on Cash on Cash Return

    Please refer to the attached spreadsheet, my property analyzer. You'll see all the columns on the left that show all the important metrics I look for when analyzing potential investment properties. After entering a minimum of data I look to the YEAR 1 COC ROI (COC) (Cash on Cash Return on...
  20. L

    Automating advancing from one worksheet to another

    2 workbooks. One called "Cash Flow"; the other called "Budget" In the workbook Cash Flow, there are different months on each worksheet (January, Feb etc). Within Budget, there are columns titled Jan, Feb, etc. I want to pull a specific cell or range of cells within January (Cash Flow) and...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top