annual

  1. R

    Excel Freeze Questions

    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...
  2. G

    Do Search Criteria

    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...
  3. W

    Need Help on Excel Leave Management

    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...
  4. K

    Lookup Formula

    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...
  5. E

    Annual leave tracker

    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...
  6. J

    Annual discount factor break down

    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...
  7. E

    VBA Pivot Table Compile Error

    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"...
  8. S

    Automatically show columns based on criteria

    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...
  9. P

    Average in Multiple Sheets

    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...
  10. J

    Array Formula to Calculate Cumulative Return Less Withdrawals

    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...
  11. C

    adding more coloums to sum if

    =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>
  12. K

    Gantt Chart Template Progress Bar Help!!!

    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...
  13. T

    Compare reported monthly bonus with reported annual salaries

    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...
  14. 6

    calculate monthly interest given annual interest

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

    How to summarize all data from a given year in a row?

    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...
  16. H

    Search for data and copy different cell if true

    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...
  17. A

    Vlookup

    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...
  18. S

    SUM Question - How to find the sum of values on an annual basis given monthly data?

    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...
  19. L

    vlookup - n/a and blank

    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...
  20. K

    Trying to build off an exisitng formula

    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 =...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top