instances

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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