instances

  1. K

    Capturing Instances

    Hello Folks , I have Column A in which Id's are given.In Column B i need to count the Instances how many times a particular ID has occurred. I can do this with Count If Formula however by this way it with give me data like below <colgroup><col span="2"></colgroup><tbody> Case Number Count...
  2. M

    Count If

    sheet 1 Column M has if statement that shows days outstanding, =IF([@Status]="",TODAY()-[@[Date Back Charge Issued]],"") which works perfect, now on sheet 3 I want count how many instances in column M are between 0-60, there are 6 instances but it tells me there is 30, when I use formula...
  3. S

    Sumif instances separately with Date idetifier

    id like to ask for help please, will it be possible to count instances separately? Please see example below. Please thank you <colgroup><col><col><col></colgroup><tbody> Duration Time Status 0:30:01 10/11/2019 13:00 Break 0:16:01 10/11/2019 20:00 Break 0:51:01 10/11/2019 21:00 Break...
  4. Y

    SUMIFS with two wildcards

    Hi everyone, I am trying to use a version of the SUMIF function to convert 'one-way' flight segments to 'round trip' segments (e.g. sum all flights trips Atlanta - Nashville, and Nashville - Atlanta into one row 'Atlanta - Nashville'. The formulas I come up are quite extensive and long...
  5. D

    Inquiry

    I have a bank of data that is updated monthly. I need to analyze said data to determine first all values above 35 then I need to look for two consecutive instances of this event. Once found, I would like to indicate for inspection if not ok
  6. D

    Multiple instances of Excel

    Hi I'm running Windows 10 and Excel 2002 (don't ask why). I like to be able to open multiple instances. At the moment, if I check the "Tools/Options/General/Ignore other applications" box I get separate instances when clicking on successive file icons (which is what I want), but the workbooks...
  7. J

    Counting instances across entire workbook with 2 criteria

    I have a workbook that I keep monthly and it has a new work sheet for every day in the month. I need to create a formula that searches the entire workbook for instances that meet 2 specific criteria. The formula will be in a separate workbook so I need to find out how to reference the source...
  8. J

    Help condensing snippet of simple code

    Hi all, As noted on earlier post this week, I'm just starting out with VBA. When I used the recorder to remove all border lines it spits this code below. Seems really long? I want to learn the smartest/most concise code I can from the get go so I don't start with bad habits...
  9. J

    Using 2 references for vlookup

    Hi, Please can someone help? I am trying to create a list from a master list based on a criteria. Below is an example https://www.dropbox.com/s/ui61g35ycc7em0u/Screernshot.jpg?dl=0 Basically, I want to create a list from the master list in row A & B I want to use the account manager name in...
  10. Y

    Formula needed to repeat pattern

    I have to populate various spreadsheets using the following number sequence: 1,1,1,1,1,1 2,2,2,2,2,2,2,2,2,2,2,2,2 3,3,3,3,3,3 4,4,4,4,4,4,4,4,4,4,4,4,4 etc.. So basically, I have to follow sequential numbers in the special pattern of 6 instances of 1, 13 instances of 2, 6 instances of 3...
  11. S

    vba messagebox return a string of data associated with other column Cells

    Hi, Trying to amend the code to include in the message box details of failed items. So in the active column, I have some cells indicating "FAILED". in the adjacent columns I have data in Column A and B. How will the below code be amended so it lists the corresponding data in Column A and B...
  12. I

    Create an Assignment Schedule/Plan

    I would appreciate any help to create a mechanism to distribute assignments to a group of people. 10 People 22 Assignments (same assignments monthly but not repeated by any one person until has done all 22) 10 instances of each (same) assignment to be done by each person OK that people be...
  13. T

    Frequency syntax

    Hello Recently I got some help on here putting a frequency function into a worksheet. I've been using & adapting this as required. This is typical of the formula I've been using. {=SUM(--(FREQUENCY(IF($V$4:$V$498="UNITED 1",MATCH($AD$4:$AD$498,Nov2018Daily!$AD$4:$AD$498,0))...
  14. A

    Count instances of an e-mail domain name across multiple e-mail addresses

    Hi, so Row A contains lots of different but unique individual e-mail addresses, thousands in fact in the format : Alan.Smith@MrExcel.com Karen.Jones@MrExcel.com Clive.Bloggs@Microsoft.com Brenda.Forbes@MrExcel.com what I need to do is count the instances that an e-mail Domain Name appears so...
  15. T

    If one column has X, then replace all instances of (a word) in another column

    Your help would be so appreciated if you feel it, thank you. If Column "E" has an "S" or "U+U" in the cell, then REPLACE the instance of "Favorites" in that row's Column I with: <tbody> "FAVORITES 1 (Solos/OCs/twins only)" Similarly, If Column "E" has an "D" in the cell, then REPLACE the...
  16. sharky12345

    Find the largest amount of instances in column if criteria is met

    I am trying to get a formula to count the values in column I but only if the value in column D is equal to B2. I need the result to be the largest amount of instances of the value found. In simple terms, and assuming the criteria is met, I need to identify the value that occurs most frequently...
  17. B

    Excel 2010 - Calculating totals but only on specific rows - VLOOKUP?

    <tbody> Unit Name June 2018 Instances July 2018 Instances August 2018 Instances Cost (pounds) dgfg 1 25 fgdfg 2 30 sfsdf 2 35 sdfsdgdfgfd 3 40 sdfsdf 6 45 sfsdf 3 50 sdfsdfsfdsdf 5 55 dsfsdf 60 </tbody> Hi Excel Community...
  18. B

    Excel 2010 - Calculating totals but only on specific rows - VLOOKUP?

    <tbody> Unit Name June 2018 Instances July 2018 Instances August 2018 Instances Cost (pounds) dgfg 1 25 fgdfg 2 30 sfsdf 2 35 sdfsdgdfgfd 3 40 sdfsdf 6 45 sfsdf 3 50 sdfsdfsfdsdf 5 55 dsfsdf 60 </tbody> Hi Excel Community...
  19. 1

    Construction Ranking Top Firms with Most Instances of Working Together

    I have an architect, HKS, and I'd like to see, when selecting their name in a splicer or drop down the top 10 other companies of other trades that they work with in a specific range of dates using a project name correlated with a project number to help delineate. IE Start Date - 12/1/2016 End...
  20. M

    Running Multiple Instances, Are more cores better?

    I need to get a new work computer that it's only use will be to use with excel, no browsing no gaming no nothing. Will be using excel 64bit. I currently have a 7700K running at 4.9GHz with 32 Gigs of RAM and a 8700K at 4.7GHz with 16 Gigs of RAM. Now in the past I have had the luxury of...

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