complex logic

  1. D

    complex array formula

    I have two workbooks like the ones shown below. I am looking for single formula and no vba to calculate regular time in columns d3:d9 g3:g9, i3:i9 in workbook 2 sheet 2 based on the date, ID, and the criteria listed below. I also cannot have any additional helper columns. I am have trouble...
  2. G

    Lookup Multiple Dates before a specific date

    Hi, I have a specific query in Excel. Need a formula or a combination of formulas to solve the below problem. I want to automate my excel sheet, to pick up all or 'x' number of the dates in descending order from another sheet before and on the specific date entered in this the current sheet...
  3. T

    Using MATCH within OFFSET without a defined range size

    Hi there, I'm working on a spreadsheet that has two columns: - The first column is the name of a particular building (i.e. 132 Wacker Drive, formatted as text) - The second column is some designation of random letters that denotes specific qualities about the building. These letters are in...
    • tps49
    • Thread
    • complex logic match nested offset offset
    • Replies: 13
    • Forum: Excel Questions
  4. T

    Running Conditional Sum Based on Month

    Hello all, I'm trying to structure a running conditional sum based on a monthly cash flow stream. To clarify, picture three elements: - A stream of twelve cash flows in one row, each one corresponding to a month - A list of twelve months in another row - A single cell that acts as a...
    • tps49
    • Thread
    • complex logic conditional conditional formula nested if function running sum
    • Replies: 6
    • 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