complex conditionals

  1. M

    Conditional Formatting/Moving Rows Based on Matching and Opposite Data

    Hi everyone, I appreciate everyone who takes a moment to read over the problem I'm trying to solve. The image below is a list of 10 records that equal a total of 4 sets of "Washes". Ex.02: Red Box On the 13th, Indiana submitted two records (5hrs and 3hrs) totaling 8hrs. So their dispatcher...
  2. W

    Resource Schedule solution

    Hi Everyone, I am trying to build a resourcing schedule and coming to a bit of roadblock in deriving a solution. Following is the data fields I am working with and require a solution to derive an output to allow only available capacity for any particular resource to be scheduled show further...
  3. G

    Look-up and Average based on 4 conditions

    I am trying to create a VBA macro to automatically calculate a three-month rolling average. Given a large spreadsheet of imported data, format seen below, I need to isolate in on the prior three months of invoices given a project designation, account code, and PO number. While the project...
  4. N

    First in First Out (Fifo) Stock balance Calaculation File.

    Hello there, I actually need help in a simple task of stock balance calculation but due to this task being a daily task and my input files having least 200 entries to work on for this task I am having many difficulties. Kindly help to kind of Automate this task (or at least reducing manual...
  5. C

    Conditional Formatting

    Hi All Hard to explain but ill give it ago Column A is activity and column B is Percentage Column A can have the same tasks but for different departments e.g Relocation - HH or Relocation - NHH But column A can have individual tasks. What i need is, if the tasks percentage is NOT 100% then...
  6. LottoMatic

    Excel expert advice needed

    I am looking for the advice of experienced Excel users regarding the "translation" of a web-based application into an Excel spreadsheet and really hope to get some useful input regarding this matter. Since year 2014 I've been working on a rather complex lottery prediction system. It is a...
  7. J

    Complex criteria for flagging text

    I need to create a formula that flags whether certain text is included in a cell, but only if that text occurs by itself, not embedded as part of a larger text string -- but it's ok if it occurs by itself and also embedded in a larger string. For example, the cell contains a list of grades such...

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