annual

Hello We use Excel 2106 via office 365. We have had countless issue with excel freezing. We have tried a lot of things and nothing seems to really fix it. The freezing isn't consistent, they happen when moving from cell to cell or saving, etc. We have turned off annual updates and went to...

Hi, sorry if title wrong, dont really know what to call this Have the following code which excludes any rows where the critera given is met. Do Until Range("A" & R).Value = "" If Sheets("checkSmart").Range(QRiskRule1 &R).Value = "Annual Review" OrSheets("checkSmart").Range(QAdvType & R).Value...

Hi, I am trying to track my Retail Employees via Excel. They submitted their responses via Google Form which have various Leave Types like Annual Leave, Medical Leave and etc. Form Response 1 is their responses, but I am trying to do a LookUp Table to add on their leaves for the entire period...

Please help me below. Hope someone can help me, I have two workbook like below: Workbook 1 As below: <colgroup><col width="72" style="width: 54pt;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2656;" span="5"> <col width="112" style="width: 84pt...

I have created an annual leave tracker for use at work. My problem is that although you can pick from a dropdown A/L pending, A/L Approved and A/L denied, with conditional rules to change colours, at the moment anyone with access can at the moment do all three. Is there a way to ensure that only...

Hi all, I have the following table to Discount the annual rate to get the present value. I am wondering if there is any formula that i could implement to get the monthly Discount factor so that i can figure out the difference. <tbody> Annual rate 8,00% Discount factor PV...

I keep getting an compile error with the script below. Am I doing something wrong? Sub PivotTest1() Dim pvt1 As PivotTable Dim pf1 As String Dim pf1_Name As String Set pvt1 = ActiveSheet.PivotTables("PivotTable3") pf1 = "(Annual) Adj Close" pf1_Name = "Annual Close"...

I need help showing only columns based on criteria. I have a spreadsheet with Q1, Q2, Q3 and Q4 data. If I type "Q1" into a specific cell (in this case cell C2 which is shaded) I want all of the cells containing Q1 at the top to appear and all of the cells that contain Q2, Q3 and Q4 to be...

Hello Dear. I have an workbook which is consist of 13 sheets, starts form (Jan,Feb,Mar,...Dec) plus (Annual), at the Annual Sheet i would like to getting an cell's average which is exist in all sheets and its (D17) the average should exclude and unconsidered zero and blank. i have used the...

Hi, I am trying to create a formula to calculate the value of a stock portfolio after a series of annual returns/(losses) and after withdrawing an annual amount based on a % of the original balance. For example, I have an opening balance of $100 and want to withdraw 4% of the original balance...

=SUMIF(table[[#All],[Date]],"="&B4,table[[#All],[CRG HRS]]) i now need to add the following which is right next to each other. (this is a pivital table <tbody> CRG HRS Sick Annual PPH </tbody>

Hello, I've been tasked to customize the "Simple Gantt Chart Template" based in Excel to an Annual Template as oppose to the weekly one that's already in the Simple Gantt Chart Template. I need to adjust the following: 1.) I want the progress bar formatting to change from purple to the...

Hello, 1. Salaries are reported annually. However, they can change each month. 2. Bonuses are paid irregularly over different months. I am trying to achieve: Show in the table "Yearly Salary Vs Bonus" the correct results for Salary and Bonus while selecting a specific Month. OR if Selecting...

Given an annual interest of 10%, how do you calculate the equivalent monthly interest?

OK, here's what I have going. I've pulled historical rainfall data and would look to summarize all the rainfall for each month so I can see the annual rainfall. Two things I need to do: 1. In Sheet Annual Summary, H2, I want it to look in Monthly Summary, Column A. If a date in Monthly...

Here is a breakdown: Annual Totals sheet contains user id information and a running total of errors Blank Error sheet contains user id with specific error counts I am looking for a formula that will perform a search in Column A of the Blank Error sheet based on a user id in the Annual Totals...

Hi, Hopefully somebody can help me with this as it is puzzling me. I am trying to auto add the total annual sales for a group of products as follows: Tab "Customer Analysis" - cell F8 = total annual turnover of a group of products, I have one tab with a product group (Data) and one tab with...

My data set looks like this: Column A Column B Date Total 03/15 62 03/16 80 06/15 100 06/17 94 09/15 81 12/15 23 12/16 68 12/17 96 If I...

Hi, I have the following formula; =VLOOKUP($A$2:$A$3000,'Q:\Curriculum Services\Advisor\EHCP Annual Review\[Master Annual Reviews.xlsx]Master'!$A$2:$U$670,11,FALSE) The result of this formula is finding a date and returning it for those students that are on the Master Annual Review...

Hello - I have the following formula =ROUND(IF(F$21=TRUE,$T$13*(MAX((F43-$C$78),($C$59))+($C$61))*$C$60,0),0) F43 is the annual premium C78 is the subsidy amount C59 is the minimum C61 is the surcharge C60 monthly pay frequency I need to add the following logic to the max formula if C71 =...