msft

  1. A

    Advance Filter vba

    When using the advance filter, it works fine, however, if I have words have similart starting letters (i.e. MS, MSFT or C, CVX, CVS...), it filters everthing. I would like to show only show data with the whole letters (i.e. if I want to see MS, show only MS, not MS, MSFT or C not CVS and CVX...
  2. A

    Refer to a cell with text string as array in Covariance.P and Covariance.S function

    Hi, I am working on a assignment where I have to calculate the population and sample covariance matrix for stocks. I know there are easier ways, but we have to use these functions. I have my data in column form in another sheet and have named the data range after the ticker of the stock. I...
  3. rjbinney

    Improved Filter 'Search' Capability

    You know what would be cool? The ability to have a "Search" box for filtered data. So, instead of clicking the little down arrow, and typing in the Search box, just having an omnipresent box... And when you type in that, your data filters automagically. What's that, you say? They already have...
  4. M

    Collapsing trading data from client allocations to get a total execution figure for the day

    Hi Folks, I'm struggling to manipulate a data set I have and am hoping someone can help with a solution either in VBA/Pivot table/formula. I have a list of trades which are executed, then this trade is split down among a group of clients. For example, we buy 1,000 MSFT US @ $10 per share. These...

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