instances

  1. R

    Count number of instances a limit being utilized

    Hi, Looking for help to calculate the number of instances wherein a assigned limit has been utilitzed greater than or equal to 90%. ColA having Date ColB having Individual names ColC having limit utilization in %age and ColD having Instances (the desired output). Case: If individual (Tom)...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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))...
  15. 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...
  16. 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...
  17. 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...
  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. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top