07/01/2018

  1. C

    Sumifs when starting with a number

    Hi, I'm trying to sum a lot of data based on date (over 7,000 lines) and based on a number and having problems. Dates in column A, amounts in column B and type in column 3. The type can vary but starts with the same number. How can I sum these? Please note, 3 and 30 are not the same thing so...
  2. M

    Array formula help

    Hi, I'm hoping someone can help with first attempt at an array formula. I have a bank statement in the form: <tbody> Index Date Balance 1 05/01/2018 100 2 07/01/2018 150 3 07/01/2018 142 4 07/01/2018 145 5 09/01/2018 500 </tbody> I would like to be able to type a date into a cell...
  3. A

    Creating a Pivot Table from rows of data

    I struggled to word the title of this thread properly... so here goes the explanation. I have a set of system-exported data that shows me how much margin/profit we make on a particular timesheet that comes in from some of our contractors. The deals that are done are split between our sales...
  4. S

    Date Range data retrieval

    Hello all, Wondering if anyone can help me with my query; I've a spreadsheet Sheet 1 contains <colgroup><col><col span="2"></colgroup><tbody> <colgroup><col><col><col></colgroup><tbody> Date From To 01/01/2018 07/01/2018 Name Time Name 1 07:00:00 Name 2 Name 3...
    • Shan9
    • Thread
    • 07/01/2018 date range horizontal lookup range sheet
    • Replies: 3
    • Forum: Excel Questions

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