plan

Hello, I have "Sheet1" Company Schedule Date Microsoft 2 hours (10h00-12h00) 13-Oct-22 IBM 4 hours (09h00-13h00) 15-Oct-22 Dell 3 hours (13h00-16h00) 13-Oct-22 Then "Sheet2", =TODAY() =A1+1 =B1+1 =C1+1 =VLOOKUP(A1,Sheet1!A1:C4,????,FALSE)...

Dear Friends, anybody can help me to find a formula to get the result. I have an inspection plan for employees to perform their job and tracking their data entry to get the result of how much percentage they did their inspection. Employees will enter each inspection job in the "INSPECTION JOB...

Hi, I have used colour scale to format the % complete cell but I need the format to be the same in column a so I can hide column b. Is there an easy way of doing this I want to keep the colour scale? Thanks <tbody> <colgroup><col><col></colgroup><tbody> Status percent complete Complete 100%...

this is my formula for IF...

Hello All, This is my fist post here so please accept my apologies if this doesn't followthe usual format for asking questions. I have a worksheet which I use to monitor staff holidays and plan resourcesaccordingly. Part of this sheet is a table with a list of about 50 staff on theleft and the...

I have a spreadsheet to track documents issued, when and a transmittal number. The transmittal can have multiple documents and each document can have multiple revisions. Where I am stuck is trying to format this data into a report based on documents or on transmittal. I have tried using a...

Hai , can any one help me to solve this issue Am creating one leave plan template , I want to restrict the entry if the leave is crossing above the target . In my template row is employee names and column follow dates, And for leave plan i put code for leave as “V” and total count by using...

Hello, I am wondering if anyone can help. I am looking to do a data import from an excel csv. I want to use this for a table seating plan. On the plan, there will be upto 50 tables. Each table will have a title (table 1, table 2, table 3 etc). Under each table there will be upto 15 guests...

Hi everyone, I could use some help. I'm trying to draft a complex IF statement to break various customers into a green, yellow, orange, or red status. I have a column to specifically state this, which will use conditional formatting per color, so our leadership can more easily see which of...

Dear All, I am trying to filter a range in excel (15 columns) and the filter criteria to be applied on a column (Column 2) which contains description. I want to apply filter on that column to get only the rows of data that meet 3 criteria such as "PMP", "PM Plan", "Project Management Plan". If...

Dear All, Can you please help me to transpose data. I have three columns "Emp_ID, Compensation Plan and Amount. I want Compensation Plan to be transposed to Basic salary, HRA, Bonus and Commuting Allowance by Columns. I have 4000 employees list which has more than 18k rows. Please help...

I maintain an aged workbook for my company that is twenty years old (approximately), containing over 20,000 lines of code. There is no documentation for the workbook. I am having difficulty successfully publishing updates to it because there is no test plan. If anyone has a guide, or a link...

Hello, I have a workbook with 2 sheets. Sheet 1 contains 3 rate plans all with their own checkbox (form) 1. Basic 2. Advantage 3. Gold I have a second sheet that all the inclusions of the rate plans. I have added on the top of the sheet the rate plans and a check box next to the inclusion...

Hoping someone can provide some help on this. I have a spreadsheet where people fill out the sheet with their skill assessments. Once those are filled out, the responses using the IF function and vlookup would populate the Development plan tab. Some of the items that get pulled into the...

Hello all. First post... Here is a simplified example of what I want to accomplish. I can change the individual's mobile data rate plan for my group each month, depending on usage. I have ~1000 lines to work with. The plans are only grouped for readability. Rate plans are: 01. 1 MB Plan -...

I have a project plan that works fine. I'd like to add a column for dependency and the date would be updated based on the finish date of the row id that is entered. Any suggestions on if this is possible?

Hi, I'm trying to sum every 3rd column up to the current week in order to have a current year to date sum up to our current fiscal week (or any fiscal week chosen). Below is the current setup, any ideas with sumproduct, offset, mod probably make sense but I can't wrap my head around what the...

i'm dealing with columns A and F. I need to add letter A to end all values in Columns A if Column F has Level or Roof in columns F. Data before modified Column A Column F <colgroup><col><col></colgroup><tbody> P1.00 LEVEL P1.09 LEVEL P1.10 LEVEL M1.11 ROOF PLAN M1.12 ROOF PLAN...

Hi I'm stuck. I have a table where I want to read the dates depending on country and row type. THEN - populate this on another table under the relevant date with a code. So here's my table I am reading from (sorry I can't paste it as a table for some reason?)...

A huge thanks to Fluff and Jack for helping me get to where i am with my formula. =SUMIF('[Production Plan.xlsx]Production Plan draft'!$C$8:$C$12,B138,'[Production Plan.xlsx]Production Plan draft'!$D$8:$D$12)/6+SUMIF('[Production Plan.xlsx]Production Plan draft'!$J$8:$J$12,B138,'[Production...