operational

Hi there, I have a huge data set (10 units and 5 years data set) that contains for each unit an indicator whether a unit is fully or partially operational or zero if not in operation. I am interested to know the number of blocks (a block is defined as a sequence of fully or partially...

Hello, I have a workbook where I want to copy specific row data based on the value of a cell in a column. Below is from my workbook. The goal is anytime there is an "x" in header "R", then the cell values from columns "A", "B" and "I" are copied onto a new sheet called "ROCC". Same thing...

Hi Experts, I have a sample table that I have create in row B7 to J16. I want to copy this table (below each table leaving one blank row in between) as many times as the number of operational groups. I have a list of operational group on another sheet. After copying the table I want macros to...

Hi all. I have a data tab where new company data gets copy and pasted into each new month, and while the raw data line items are the same (same report each month) sometimes there are additional line items added and this pushes the rest of the data down. I want to separate big and small ticket...

Looking to find a formula that will help me find the exact amount of time that falls within a given range. Here is my situation: I have been tasked to find the amount of time that falls within an "Operational time". The range of this operational time is between 06:00:00 and 22:00:00. Here is an...