count based on range

Dear MrExcelites, Need your help in modifying below macro to count hyphenated range as below. Sub ConcatenateRefDesignator() Dim a, w Dim i& a = Cells(2, 1).CurrentRegion With CreateObject("scripting.dictionary") For i = 2 To UBound(a) If Not...

Dear All, I require a formula to count the respective colours for each employee as below:

Before submitting this message I did review two similar message board entries, but I wasn't able to figure out how to make the formulas work for me. (I reviewed Count 30, 60 and over 90 days based on Name in Column "A" and Countifs or sumproduct - date range and multiple criteria ) Basically...

I have to tables, In one one table I need to find out how many times an item exist, but if the item is in duplicate it should take it as 1 Refer the picture - I need to get the answers as shown in RED colour ( these were counted manually and entered )

Hey guys! New to this forum, and trying to slap together a project to make my mornings a bit easier. I'm looking to count all of the email in a folder and all of its subfolders, and give me a count of each date in the folder. As of now, I have them exporting to excel and giving me a count...

Hello, I am looking some help in getting distinct count by criteria. For example if you refer the below table I brought the distrinct count by using formala {=Sum(1/Countif(A:A,A2))} however, in additon to this need another conditional criteria. If given % different for no then it should...

I was looking for help on creating some code to find numbers 1 to 20. The code would search for any numbers 1 to 20, in the ranges E3:E10, F10:F17, H3:H10 (I will need to be able to add additional ranges in the future). A positive result ones that have data in the cell to the right of...

I have data similar to below...I would need help in getting coutif formula ...I need count based on names and it should exclude the "Zero" value lines...for each amount type... I need one count for aaaa & bbbb and rest all other names should come under other names.... <colgroup><col><col...

Hi All, I want to count the total number of Pass and Fail based on Column 1 (Originating) site. For. Eg., If I select US, I should get 3 pass and 1 Fails, and if I select UK I should get 1 pass and 1 fails. Can someone please help? <tbody> Originating Site Description US Pass US Pass UK...

Hi, I'm trying to reference a specific list and find a match in an array that has the most commonalities with that list. The goal in the table below would be to return the name "Larry" as he has the most matches to the target list. <colgroup><col width="88" span="6" style="width:66pt">...

Hi A have a row with 0 and 1 and they comes in a serial. A wants a formula to calculate the largest/ second largest serial of 1's in a row. I wants to variate were to start and stop, sometimes I have to start counting in a middle of a serial of 1's 1111111110000000111111000000000001111111111...

The names I need to count are in column e and the vales of numbers are in r. I tried =COUNTIF(E:E,"r2>=15") Any help would be appreciated.

Helo expert, Here again, i'm asking a formula to solve my issue. Like picture i put on this below: On yellow fill cells are the result that i need (i count it manually). Basically, i need to count how many time the number appears (doesnt matter the sums of them). e.g.: on "ITEM 1" the...

Hello, I have a reference sheet linked to a Sharepoint file similar to the format below. The blanks do contain the reference formula which is causing issues. I need to figure out how to get the percentage of data points above 1.1 based on the last 10 days with values. So for example, 11/15/17...

Hi, I would appreciate any help with the following problem i have: In 'Sheet1' i have 3 populated columns with the headings 'Date', 'Agent' and 'Stock' and the relevant data underneath to include the dd/mm/yyyy, the selling agents name and the stock code of the item sold. In 'Sheet2' i have 2...

Dear Forum, I have a frustrating problem and need help. I have a worksheet where it identifies the number of times keywords appear in a list in Column A. The worksheet then identifies the keywords and lists them in Column F. each separate instance of the words has a corresponding number in...

I am trying to create a formula that will count the number of results that fall within a certain range with text. For example all Canine results that are greater than 1 but less than 7 the formula I am looking for would return a value of 2 in Cell H2. The formula I have returns an error...

Hey guys! I am new to MrExcel and I have a confusing question for you all. I am working on an attendance tracker for work and we have a unique policy that for every 4 occurrences someone is late less then 25 minutes (tardy) they are given .5 a point towards their record I use "T" to identify...

i need to count numerical values greater than 3 and less than 3 values from duplicate multi criteria. i have column A which have locations and Column B have numerical value . just need to count numerical value in front of on first available location others duplicate location should be zero. A...

How can I count the number of didgits in a range up to a max value? If Cell A1 had a value of 23. How can I calculate the B3:B12? <tbody> A B 1 23 2 3 Number of 1's (1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 21) 13 4 Number of 2's (2, 12, 22) = 4 5 Number of 3's...