published

  1. H

    Transpose only few columns in excel and add as new rows

    <colgroup><col><col><col><col><col></colgroup><tbody> Can you please suggest to transpose this data in excel Actual Published Forecast ZDP ZST ZMAT Expected Published Forecast ZDP Published Forecast ZST Published Forecast ZMAT </tbody> Thanks in...
  2. N

    ISBLANK with seperate IF statements

    Good morning, I have the following formula that works well for the 1st part of my requirement but need help to meet the second part of the requirement as well. =IF(ISBLANK([@[First TAG meeting]]),0, TODAY()-[@[First TAGmeeting]]) work well but once a project is complete and there is a date in...
  3. M

    using googlefinance to get stock exchanges

    Can googlefinance() return the stock exchange for a given ticker symbol? I track a porfolio of shares in excel and until last week I was getting share data from the yahoo API. They just pulled the plug with no warning so I'm now getting it from google finance by importing a google sheet which...

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