fund

  1. N

    Copy formula to non-blank cells in table and concatenate results

    Hi All, Below is an extract of a table of data I currently have which in reality is much larger with 54 risks and 90 funds across the top. <tbody> Fund A Fund B Fund C Fund D Fund E Risk_01_RT X X X X X Risk_02_RT X X Risk_03_RT X Risk_04_RT X X X Risk_05_RT X X X X...
  2. D

    Complex Average growth formula

    In the tables below I've outlined a small sample of the data I currently have. On the first table "Raw Data" is a specific fund code with multiple month-end dates in the second column and that funds current yield for each of those month-ends in the 3rd column. Now some of the funds in this...
  3. M

    This formula uses more levels of nesting than you can use in the current file format.

    I am trying to use my formula: <colgroup><col></colgroup><tbody> IF(AND(N7="common basket fund for HIV",U7="WORLD DIABETES FOUNDATION"),"Non costed",IF(AND(N7="common basket fund for HIV",U7="PAYS BAS - NETHERLAND"),"Non costed",IF(AND(N7="common basket fund for HIV",U7=" PROJECT: GLOBAL...
  4. D

    Lookup Help

    I have a tab in a spreadsheet that each month gets a brand new dump of data for 3 different mutual funds. For the month ending 11.30.17 the total number of holdings for all 3 funds was 533 and for 12.31.17 was 544 (they are listed in order... so all of one funds holdings are from say row 2-100...
  5. B

    Formula Help: Financial Liquidity Calendar

    Hi, I work for a college endowment and am creating a spreadsheet/calendar that has all of liquidity terms for our different funds. The idea is to use the =TODAY function to have the spreadsheet be responsive and continuously be current. I'd love your help in developing a formula that will...
  6. G

    VBA Web Scrapping: select item form List Box (DropDown List) by Name

    Hi, I'm trying to write a VBA script for Web Scrapping. I have to select an item form a ListBox (********** tag in HTML) by its name. Does anybody know how to do this? I'm using this libraries: 1. Microsoft Internet Controls 2. HTML Object Library Here you have some of the HTML code...
  7. H

    Transform single column into multiple columns & rows

    I have data in this format <tbody> A d B e C f A g B h C i </tbody> and I want <tbody> </tbody> <tbody> A B C d e f g h i </tbody> for about a thousand rows; and preferably not a macro. Pretty sure this must be a common problem, but couldn't find it here. I thought it was...
  8. D

    Optimal Cost Structure Help

    Hey guys! Been busting my head trying to do something in Excel; but haven't been able to reach a satisfactory procedure. So here's the case, on bullets: 1) We have to open a fund to handle our investments. Each fund has a cost of $15,000 for opening, and each one can handle twenty investments...

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