mths

  1. T

    Months on Hand Inventory

    Hello All, I'm currently looking for a way to calculate months on hand inventory. Looking around this forum I could not really find a simple way to get rid of my problem. My dataset is as follows; <tbody> Model Region Configuration Measure Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19...
    • TG2812
    • Thread
    • configuration inventory model mths region
    • Replies: 13
    • Forum: Excel Questions
  2. M

    How to get the last date for each 12 Mths?

    Hi Would you know how I would get the last (highest day) value for each months? IN the example for the month of January the last date is January 28 and I need to get the value next to it which is 162. I need a formulae range that would include the entire year that gets the values for each...
  3. F

    Convert days into Years/Months/Days

    I have two dates subtracted which gives yields 867 How to convert to ? Yrs ? Mths ? Days
  4. I

    VBA - insert column and vlookup data

    Hi, I have a huge data and multiple worksheets and need to consolidate into 1 "Summary" worksheet. Below are the steps I am doing.. 1. add new Column in "Summary" - "July-17"　 2. vlookup new number for the new month from ALL the worksheets　 3. If there is new customer in any worksheet, add...

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