complex conditionals

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...

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...

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...

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...

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...

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...