count

Hi, Is there a way to count the number of viewers of each report (may it be a ppt or xlsx in a shared drive) with maintaining and running only one macro? Example: I have these files in our shared drive: Monthly Amortization Report 2024.01.26 12-56.xlsx Monthly Accrual Report 2023.12.27...

Hi, Sample of data: BCDEF1ABAExpected Result21.31.21.3431.311.911.9241.21.2511.91.361.21.2711.911.9811.91.391.365.71011.911.91111.91.31211.97.8131.211.9141.211.9151.2111665.77.81765.71.3188.911.9196.61.320881.22141.3 Before counting number of occurence value in Column E, these 2 steps must...

Thank you for your help in advanced. I need to help to understand what the formula should be for the total for each column. It needs count Yes once per name. In this name, subject 1 should calculate 4, Subject 2 should calculate 3 and Subject 3 should calculate 2. If I changed row 5 from Name1...

I have a report that shows how many views datasets have each week. For each row I wish to calculate 2 values: - Total Zero = The number of weeks with zero views after the data has been viewed in a prior week - Consecutive Zero = The number of consecutive weeks with zero views, where the most...

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

Hi, CDEFG1Var AVar Bexpected result...

I have a list of people and a list of team number. Every person is attached to one singe team but its name appear several times (I made a simple table). I would like to know how many people there are in a team (3 in team 1 and 1 in team 2 in my example). I know it's not a big deal but I can't...

Hi, Sample of 100+k rows: FGHI1Bexpected result...

Good Morning, I am looking for some assistance with coming up with a formula. Using my attached image you will see in column G there are Hold Reasons and in Column H there are Root Causes. I need a formula that can be used in a new column that shows a count of the different combinations...

Hi guys, I need help in trying to get a "rank" of text. Let me explain. I have a spreadsheet where column A has repeating values, while column B shows the rank/count of these values. I have attached a screenshot of a simple example. The letter A shows up a total of 3 times, and column B is...

Good afternoon, I am after a formula that will count how many teaching period each instructor will be teaching during a course. As some lessons are over 1 period long I can't just use a simple COUNT formula. Is there a way of creating a formula or array that will do this? Many thanks in advance.

Hi All, I was wondering if anyone know how to count the number of Sick Occasions in Dax? i know how in Excel but dax is a completely different beast. Looking at the example i have posted. I want it to show 0 if they were not absent. Then increment once they become absent. But then they return...

Hello Excel lovers, For a better understanding, please find the picture. Here, my input Column is I, J, K My output column is the P column (I want to get the Xlookup result for nth number.) To count the number of occurrences, I add a helper column L I don't want to add this helper column. I...

Hi, I need a count formula that counts names across multiple columns. I need to know how many people attended Philadephia. The answer is 5. Then pull the formal down to know how many attended Orlando = 6. please note the blank cells are blank b/c there is a formula iferror return "" A1 first...

Good evening fellow excelers, Is there a way to write an XL formula that will count non-formulas in a range? I know this is gotta be simple to do, but I just can’t seem to wrap my mind around how to do it after about half an hour to an hour of trying. Thanks for any consideration to this...

Hey guys, I'm writing a code to count and store values to reference how often something is referenced in a class. I'm trying to write a code that counts with one button (this is complete) and stores historical values in another column. This is where I'm having issues. My counter is set in B2...

Hi all, I've been struggling with a formula for GSheets. I have the data in another sheet and I want to count how many time does a name appear during 7 columns. Any help is greatly appreciated,

Hi, please could you help me? It is difficult to explain, but I will try. I want to count distinct of Tests in my Excel table. For example for Test_1 I want to count all Tests, but only that kind of tests which have at least 1 Cond, which is in the same Cond as Test1. Result is 8 because...

Hi, I am after some help to count the number of consecutive weeks an individual has been paid. Difficulties with the data set are the duplicates values. I have explored and trialled countifs but haven't been able to incorporate the portion around a consecutive count. I've included an example...

Hi Experts, I been thinking and try change current formula but not succesful to meet my need. Current Formula : Start from currrent cell GIJ1datatotalCount230.63240.150.860.3J3J3=IF(I3="","",COUNTIF(INDEX(G:G,ROW()+I3-1):G3,">0.5")) The best solution I have tried so far : but the result...