jan-18

  1. subrosumon

    data from large database

    Hi Expert, Apologies for consuming your valuable time. I have a large Data base which is showing with Month as well as client. (Following example Month, Client and amount) I want to show to use another sheet as voucher format where All transaction e.g. Month of Jan-18 and a Client of ABC to be...
  2. Sean15

    SUMIFS formula

    Hello: Excel 2010CDEF2Amount Posting layerStatus31,250.00BF from 9/30/1742,900.00Oct-17 c-card5294.49Oct-17 c-cardcleared6111.87Oct-17 c-cardcleared7394.96Nov-17 c-cardcleared8141.97Nov-17 c-card9406.62Nov-17 c-cardcleared101,445.00Nov-17 c-cardcleared111,897.27Nov-17...
  3. R

    INDEX MATCH with IF

    Hi i was wondering if i could use index match with IF to find the production volume by matching the delivery date and post it to the relavant month in sales <colgroup><col><col><col><col><col><col><col><col><col><col span="5"></colgroup><tbody> Production Volume Sales Invoice...
  4. Y

    Date Range - Count Days per Month

    Hi, I am seeking a formula to calculate the days per month assigned to each job. For example job 1 is 98 days and the formula automatically assigns the 98 days across the Prior Year (2017) and Jan-18 to Mar-18. Similar formula for each subsequent job based on the start and end dates of each...
  5. A

    Double vlookup/sumifs

    Hello, Apologies if this is basic or has already been answered, but I'm stuck on getting a formula correct. In essence, I have a sheet with: 1. A tab (Tab1) with information entered for each month Month Sales Cost Jan-18 45 3 Feb-18 22 1 etc 2. Anther tab (Tab2) listing each...
  6. J

    Pivot table difference column (same field)

    Hi, I am trying to create an additional column (field/item/calculated?) in a pivot table to show the difference row by row. My data is like this: <tbody> Customer Date $ ABC Jan-18 50 ABC Jan-18 50 ABC Feb-18 75 ABC Feb-18 75 XYZ Jan-18 125 XYZ Jan-18 125 XYZ Feb-18 150 XYZ...
  7. A

    Index match conditional

    Dear Excel Community, Currently I have a parameters table that looks like this. <colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody> Type AB A AB A AB A AB A AB A AB A Dispatch 50 10 50 10 50 10 50 10 50 2 10 2...
  8. C

    Match (?) Help

    I am trying to create a dashboard where if a particular month is selected the relevant target for that month/period will appear. So far I have the below and am stuck on the final formula for the matching of targets to months: <colgroup><col width="12" style="width:9pt"> <col width="169"...

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