shane_kidani
New Member
On the attached workbook, the 4th tab, I would like some help figuring out the following:
1. Columns T through W will return "1" or leave cell blank if conditions are met. -By the way, I have the condition formulas structured, albeit poorly.
2. Since the amount of rows of data will always change, be able to copy a formula into a completely separate workbook.
For example:
1. T2 would return "1" if the elapsed time in cell S2 is less than or equal to "6:00" AND the number in cell O2 is zero. I am trying to get the formula to be able to calculate through all cells with data in columns T though W, but as you can see there are many conditions and variables.
2. Let's say the attached workbook contains 1,000 rows, but the next report would contain 2,000. Is there a way (with the "$", perhaps) to have the formula be able to do such a thing?
1. Columns T through W will return "1" or leave cell blank if conditions are met. -By the way, I have the condition formulas structured, albeit poorly.
2. Since the amount of rows of data will always change, be able to copy a formula into a completely separate workbook.
For example:
1. T2 would return "1" if the elapsed time in cell S2 is less than or equal to "6:00" AND the number in cell O2 is zero. I am trying to get the formula to be able to calculate through all cells with data in columns T though W, but as you can see there are many conditions and variables.
2. Let's say the attached workbook contains 1,000 rows, but the next report would contain 2,000. Is there a way (with the "$", perhaps) to have the formula be able to do such a thing?
