unique counts

Hi, I have an excel file with two sheets S1, S2 (please see below for sample content). All sheets are in one excel file. For each cell in sheet S1, I have to check whether there is/are an/multiple entry/entries in sheet S2. If there are entries, then I would like to count the unique types and...

I have a report that shows each line item on open orders as it's own row. So let's say there are 3 orders with 3 items each. The report would have 9 rows and might look something like this: <tbody> Order # Order taker Item Qty 123 Bob stuff 2 123 Bob stuff 2 123 Bob stuff 2 222 Jane...

Hello, I am preparing a usage report for a school's Learning Management System. I have downloaded the raw data of each login into an Excel file. Each row down the worksheet represents one login. Each column across the page represents some identifying information about the user. These columns...

Please help me! I'm trying to sum filtered values from column J (course credits) based on unique values from column F (unique course ID). The desired result would return a count of 3 unique values (courses) for column F and a subtotal of 10 (credits) for column J. <tbody> A B C D E...

Hi, I have function to count how many many times name from column C (sheet M1) appear in range (sheet CSTG, column B): =COUNTIFS(CSTG!$B:$B,'M1'!C7) <tbody> Column C Column D - only count Audi 5 BMW 7 VW 10 Fiat 3 </tbody> Now in column Q (sheet CSTG) I have different values, like...

I have a worksheet that has a column of cells but each cell has one to several field names. I find lots of guidance on counting unique values in a range of cells BUT not within cell and ranges. The values in the cells are alphanumeric field names such as COLCOD, A15OB, ACCTNO etc. The goal if...

hi, I'm using Scripting Dictionary to make unique list: Dim count_result As Long count_result = 0 Set dict = CreateObject("Scripting.Dictionary") For i = 3 To last_row looking_string = wsC.Range("O" + CStr(i)).Value If Not dict.exists(looking_string)...

Looking for a way to count the number of unique values. Note that some cells have multiple entries. Need to ignore the text and dates and just count the number of “numbers” even though they themselves are in a text field. So for the example below, the number of unique values is 12. Note: need to...

Having difficulty solving this one: I have a large spreadsheet, but am mostly interested in 2 columns of data (both text fields). A simplified example below: <tbody> Teacher Student ID Sally 1234K John 5678K Sally 1234K Peter 1234K Peter 5678K Sally 8765K John 1234K John...

Okay. So I have a large amount of data that tracks employees with their business line, service area, activity and hours, which they have to fill in weekly. I have a pivot table which groups so it shows the number of hours per business line or per business line + service area or per business line...