trs

I am trying to have a cell state Compliant or Non-Compliant based off other cells. If TA Error = FALSE and Days to EAS - TRS Completion is greater than or equal to (>=) 180 show Compliant OR if Days to EAS is >= 180 show Compliant. This is what I have so far, but it doesn't seem to work...

I am trying to have a cell state Compliant or Non-Compliant based off of results in other cells. I need TRS Compliance to say Compliant if, EAS is greater than 6 months from today or the TRS Master = Y. My current formula for TRS Compliance, =IF(OR([@EAS]<=Table1[today + 6 months],[@[TRS...

I am trying to have a cell state Compliant or Non-Compliant based off of results in other cells. I need TRS Compliance to say Compliant if, TRS Master = Y or MCTIMS - TRS = TA My current formula for TRS Compliance, =IF(OR([@EAS]<=Table1[today + 6 months],[@[TRS...

I have this averageif formula, =AVERAGE(AVERAGEIF(F4:F9,{"TRS","TRP","TRX"},G4:G9)) This works well when I have all of the criteria in the dataset, but if the dataset only has "TRS", the averageif returns and error because I think it's trying to locate all of the words inside the formula. How...

Hi everyone, I need your help to figure how can I take from a piece of code an table to excel. I find where table is and I create a variable to put the table in, but when I try to use that piece of code like html document, vba shows me this message: "Run-time error '424': Object required"...