occurrence

  1. C

    Employee Attendance Tracking with Points - help with SUMIF Formula

    I am working on an employee attendance spreadsheet that is based on a point system. Point values are associated with different absence reasons and tracked on a rolling 12-month calendar. I was able to successfully complete a spreadsheet to take care of this part. However, I am unable to figure...
  2. M

    Average or occurrences help needed

    I need to quickly evaluate pump rates. I have an output (pump gpm) that gets recorded to excel every minute in a new row. The pump turns on an off multiple times a day depending on build up. What I want is to know the number of occurrences a day that the pump turns on and the average gpm...
  3. K

    Finding where an item occurs in a list

    I have a list of values. These particular values are numbered 1 to 90 (in A2:A91). The values in column B (B2:B91) are 1 to 45 with each occurring twice. I want to setup formulas on a different location on the sheet so that I can have a list of the where each occurrence of the values occurs...
  4. P

    Most characters

    •••W•••••W11111W22222W•••••••W11•1W1••••••••••W••111•11WWW I have this text string in a single cell and need to count the longest occurrence of dots (in this case 10) can anybody help
  5. B

    Remove Duplicates with in a column

    Hi I have an excel sheet - Column A contains Phone Numbers separated by a "||" Symbol - Requirement - I want to remove the repeat occurrence of a number with in a cell and retain only one occurrence <tbody> Occurence Post Dedup - Result 18002821376 || 18005675803 || 18002687708 ||...
  6. K

    Number Of Occurrence

    <tbody> sunday monday tuesday wednesday thursday friday saturday peter <tbody> 09:30 - 15:00 </tbody> <tbody> 15:00 - 22:45 </tbody> <tbody> 09:30 - 15:00 </tbody> amy <tbody> 09:30 - 19:00 </tbody> <tbody> 13:15 - 22:45 </tbody> 09:30 - 19:00 before...
  7. R

    Finding nth occurrence using SMALL & SUMPRODUCT

    As the title says I need to do a nth value/occurrence look up. I was able to find a maximum value by using MAX in conjunction with SUMPRODUCT and thought I could apply the same logic by using SMALL along with SUMPRODUCT. My test sheet is set up as follows: A3:A17 contains letters which are A, B...
  8. P

    Word search find occurrence

    I have this piece of code working but problem is I need to find the LAST occurance of a particular search string: With wrdApp.Selection.Find .ClearFormatting .Text = mytext .Forward = True .Wrap = wdFindStop .Execute...
  9. L

    Urgent!!-Find Cell Address of Last occurrence of a String in a column

    Hi, Need a little help with a formula, I am trying to find the cell address of the last occurrence of at string "LLL" in a column. Range- (I4-I3001) the formula in cell A1 will check the last occurrence of the txt "LLL" in the above column (I4:I3001) and return the address of the same. EG:-...
  10. D

    Adding multiple lookups using INDEX MATCH functions

    I am trying to add up certain numbers in each row. So each time 4.4 shows up i want the number to the left of it (can be a different number). At the moment i have INDEX(C5:CN,MATCH($CT$2,C5:CN,0)-1). CT2=4.4 This gives me the number left to the first occurrence of 4.4, but I am trying to get...
  11. most

    Count date occurrence, mine code doesn't work

    Hello! Can anyone help me explain what's wrong here and how to solve it? {=SUM(IF(MONTH(named_range)=C3,1))} My expectation is that the code should count occurrence of a specific month of the dates in the green field(named_range). Month 2-12 works fine, but month 1 return the number of rows...
  12. M

    Appending specific text at the end of every row depending on occurrence of a number

    Hi, I m new to VBA and my problem is explained below with example i need to go from this : <tbody> rank name 1 jon 2 alex 3 william 4 josh 5 jamies 1 sarah 2 angela 3 haley 4 julie 5 sofia </tbody> In this table , i need to append a text which has no column name. 'A' has...
  13. T

    Determine if a date falls between two dates if duplicate names

    From the list below: Start Date,End Date,Names 12/10,15/10,Kevin 14/10,16/10,Jason 14/10,20/10,Kevin I manage to highlight the name if the occurrence is more than once. =COUNTIFS($A$2:$A2,$A2,$CF$2:$C2,$C2)>1 I need to create a conditional formatting to highlight second occurrence of Kevin's...
  14. P

    SUMPRODUCT to find nth value

    Hello, I'm trying to create a formula using SUMPRODUCT that takes into account multiple criteria to return a sum. A portion of the formula is found below for a MTD calculation. However, I can have multiple occurrences of text that are the exact same. I want to be able to return the nth value...
  15. DaddyO

    No VBA: Return Value From One Column Based On The First Occurrence Of A Date In Date Column

    Using structured references if possible, I need to: 1. Find the first occurrence of a particular Date in a Date column. 2. Return the value in the GmID column from that Row. Thanks for any help! Here's the test spreadsheet: https://1drv.ms/x/s!ArIAG4a3p8D7h5ckByrx6pojIkaiVg
  16. B

    Index/Match return column header (multiple occurrences)

    Hi I am trying to lookup a value in Column A then look across that row to find a string and return the Column header. There may be multiple occurrences of the string in that row and I need to return all column headers where there is a match. The data I am looking up is on a closed workbook. I...
  17. K

    Expand Range until the first occurence of a specific text - VBA

    Good Day Folks I have been trying to expand my selection until the occurrence of "Total"(not including) in the same column. The below code gets me to the cell above the occurrence of "Total" but doesnt expand my selection. Range(Selection, Selection.End(xlDown)).Find("Total", , xlValues...
  18. B

    Contains Subarray

    I'm trying to figure out a formula to determine whether an occurrence contains a value with the data in this sort of format. In the example below, I'd like the formula to output TRUE if the occurence contains the number 2, and false if it doesn't. I've been trying SUMPRODUCT and INDEX with no...
  19. M

    Repeat at regular interval after first occurrence

    I have a data like below. Lets say for the first occurrence in the First row, I use a formula to specify that a value, say 55, must be inputted in Feb and the data inputted every 3 months subsequently i.e the next one in May. I tried using mod and count but not working as I want it to. Will be...
  20. T

    Formula to highlight individual occurence

    Hi, Dos anyone know a formula to use in conditional formatting to highlight occurrence of values. 1 3 3 3 4 4 1 So for example 1, 3 and 4 would be highlighted. So Basically just one occurrence of each cell. Regards,

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top