1. T

    Average Age using decimals

    Hi I have been given a sheet of ages and asked to calculate the average. However the ages are in decimals e.g. 10.04 = 10 years and 4 months, 11.11 = 11 years and 11 months. Any ideas how to calculate an accurate average in excel?
  2. P


    Just need some help with an additional ask. I have the following formulae, which provides aged analysis on all of my data. There are further ages (this is a sample) SUM(COUNTIFS(DataWIP!$H:$H,{"A- High","B - Associate - Hi"},DataWIP!$AL:$AL,"WIP",DataWIP!AN:AN,"<="&0))...
  3. K

    how to fill cell m34-dh34 with certain condition?? (vba)

    note: Time: Cell D6 Date Format Birthday: Month, Date, Year cell D3-f3 Age / Age: cell m 15 - dh15 Cell M34 - DH34: Place in its contents PINNACLE VALUE according to Time value Pinnacle Value: the result of addition of D3-F3 cell , THERE IS of 4 Pinnacle value . Iam looking for formula or vba...
  4. B

    Need to know formula to sum up 3 largest rates depending on age factor

    Hello, I am making rate calculator for clients to type in their ages and the ages of their dependents to know their insurance premium. Blue Cross has the rule that subscribers only pay for the first three dependents under the age of 21. (the largest 3). These ages and rates are only a sample...
  5. B

    Index with 3 Matches

    Hi - Could someone kindly help me work out the below (a little stuck with it); =INDEX(Sheet1!AG2:AK36,MATCH(A10,Sheet1!A2:A421,0),MATCH(A1,Sheet1!AF2:AF421,0),MATCH(B9,Sheet1!AG1:AK1,0)) Been messing around with it for ages and just can't get it to work. Thanks in advance!

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...