equity

  1. J

    LARGE IF OR question

    Hello, Currently I have the following formula which works great: {=LARGE(IF($Z$1:$Z$10000="EQUITY",$AA$1:$AA$10000),J23)} If I then wanted to include other candidates for large, with different text values than "EQUITY", all in column Z, how would I expand the above to include these?. Been...
  2. E

    dictionary question

    Hi, is it possible two have two keys for each value? Here's the problem I'm facing with. I have some balance sheets for different people with different dates in different worksheets and files. I want to extract certain data such as the numbers of equity or debt from balance sheet, and rearrange...
  3. J

    SUMPRODUCT error when blank cell

    Hi all, Hopefully an easy one. =SUMPRODUCT(($C:$C="Equity")*($E:$E)*(B:$B)) Essentially want to multiply and sum Column E and B together if C = "Equity" Columns E and B contain empty cells, which appears to be the root of the problem. Any ideas? Thanks, John
  4. B

    Predicting an IRR

    I am trying to solve for IRR. If I want to achieve an IRR in any year of 9% and I have my cash flows but need to solve for sale equity, what should I use? So if in year 4 of owning a property, I want to sell it to achieve a 9% IRR and I have my original equity number and my cash flows, how do...
  5. B

    Predicting an IRR

    I am trying to solve for IRR. If I want to achieve an IRR in any year of 9% and I have my cash flows but need to solve for sale equity, what should I use? So if in year 4 of owning a property, I want to sell it to achieve a 9% IRR and I have my original equity number and my cash flows, how do...
  6. D

    SUMIF - - but I need more ...

    <colgroup><col><col><col><col><col><col></colgroup><tbody> Calc Type ExpRatio Holding% FundCost Mixed $36,233 equity 0.69% 9.35% $250 $29,026 mixed 0.60% 7.49% $174 0.38 $41,933 fixed 0.97% 10.82% $407 $32,045 equity 0.77% 8.27% $247 $9,934 mixed 0.63% 2.56% $63 0.51 $8,761 equity...
  7. M

    VBA How to extract specific values from pivot table

    Hello, I am starting to learn how to extract data from pivot tables. However, I have found some easy examples online but unfortunately I have a complex pivot table that constantly changes of number of rows and columns due to the month and year periods changing. Thus, I need to extract specific...
  8. I

    Sum cells of each row in a selected range

    Hi guys, I wanna sum the cells of each row in "Rentabilité 2" range and have the result in the column right next to it. Here's the code i made so far, i managed to select the range under "Rentabilité 2", but don't know how to sum each row, do i need a for loop? Sub sum() Dim lngLastRow...
  9. J

    Format Formula to not change in Table

    Hello I am having a problem with what appears to be a type of Absolute vs. Relative references - but I am not too sure. Using Excel 2016 I have created two tables. Table 2 is a Summary of Table 1. Table 1: <tbody> A B C D 1 Fiscal Period 2006 2007 2008 2 Book Value 1.668 2.380 3.596...
  10. M

    Presenting a Financial Statement

    Anyone have suggestions on which formulas to use / how to do a presentation of a Statement of Changes in Equity on Microsoft Excel?
  11. C

    IRR formula

    I am looking for help with the following: Assume this example: Internal Rate of Return $-5,000, $2,000,$2,000,$2,000,$2,000,$2,000 using =IRR(above sequence) I get an IRR =29% What I am hoping for is to use "Solver / or a formula" to achieve the following. I would like to find out what % to be...
  12. V

    Excel Template for Equity Stock

    Hi, I am looking out for some good excel template, which can help me to keep track of my equity investments. Thanks a lot in advance Vijay

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top