compliance

I know this should be simple, but for some reason it's not working for me. I'm trying to locate in a cell the following phrase "5. IS THIS A COMPLIANCE SERVER, IF YES ICD MUST BE PROVIDED:" in a cell that looks like this: PLEASE COMPLETE THE FOLLOWING, ONE SERVER PER TICKET PLEASE. 1...

Hey guys, I've been trawling the internet, and it's many excel forums, and am yet to find exactly what I'm looking for! I've been working on a training matrix/schedule and my boss has asked me to come up with a % compliance figure. I really need some help understanding exactly what 'COUNTIF'...

Hi, I have a looping macro - it runs successfully until it gets to the the 103 item in the filter. I receive the 'Runtime error 5: invalid procedure call or argument'. When I debug it takes me to here Worksheets("Labor Compliance...

I'm not quite sure if I'm using the right formula to be doing what I'm trying to do, but let me walk you through what I'm looking for. I'm trying to put together a dashboard that facility managers for my company throughout the US can use as a one stop for all of the compliance documents that...

Hi guys, I want to plot a graph with this data <colgroup><col><col><col><col><col></colgroup><tbody> Compliance Non Compliance Transporter FARMER DONE FARMER DONE A 47% 360 53% 400 B 0% 0 100% 40 C 60% 360 40% 240 D 55% 240 45% 200 E 36% 320 64% 560 F 0% 0 100% 80 G 27% 120...

I'm having difficulty in creating a drop down menu thats dependant on the 1st drop down. For example, I have a list of product lines, Regulatory Compliance, Anti-Fraud, Financial Custom, Financial Control. I have a separate list of the items that relate to Regulatory Compliance, Anti-Fraud...

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 work in clinical research and would like a program to calculate a patient's medication compliance between visits and to share with the whole team. This would make a lot of people happy and it's something we can print and place in the chart. Formula Calculate the percentage difference between...

Hello all, I am new to the forum and in need of some expert help with formulas. I can typically figure out a formula or find what I need by searching online. However, I am trying to do a very complex calculation and am running into issues or not finding the answer online. I know how to do the...

Hi I have a macro that populates a word document template from a table in excel. Users press a report generator button and it creates the file. However, for the cases as shown below where the user selects "compliance", "scope", or "vendor" in a specific cell i want the code to return a message...

Hello. Could you please help me with formula for this one? How I can get % of how many are "Fit in SLA" ? If there are 4 in, 1 out? <colgroup><col></colgroup><tbody> Fit in SLA Fit in SLA Fit in SLA Fit in SLA Out if SLA </tbody> Thank you in advance.

I have two spreadsheets: 2017-08-03 Compliance Response and Current Compliance. Both spreadsheets have the same column and column headers. 2017-08-03 COMPLIANCE RESPONSE/NJN Tab - I need to add the data from column K using column L as my lookup value to column H of the "CURRENT COMPLIANCE"...