distinct

Hi Folks, Struggling with this, even having read threads here about functions that may help. Looking to total unique dates based on criteria in another cell (not an overall total of unique dates). e.g. A B C D E F G Resource Name Position Hours Date...

I'm having a hard time with this, and I'd really appreciate some help. I've got 8 compounds distributed across 4 containers. I need to see if there are any compounds for which the container is empty. I can use =SUMPRODUCT(1/COUNTIFS(tbl[COMPOUND],tbl[COMPOUND])) to return number of distinct...

I am currently generating a distinct list from a list with duplicates using: =IFERROR(INDEX(C15:C50, MATCH(0, INDEX(COUNTIF(D50:D50, C15:C50), 0, 0), 0)), "") However, when the source list changes, the entries of the distinct list will (potentially) reorder. This is messing up another purpose...

This code is taken from here: https://www.ozgrid.com/forum/forum/tip-tricks-code-no-questions/advanced-excel-integration/7960-create-a-unique-list-with-ado-sql-from-closed-workbooks-xl It removes duplicates using the SQL command DISTINCT. The problem is it works for a small column of...

I am posting this in lieu of an unanswered thread -- "VBA to List all Possible Pairs of X,Y Data in two Columns" https://www.mrexcel.com/forum/excel-questions/1038311-vba-list-all-possible-pairs-x-y-data-two-columns.html I have two columns of X,Y data. I need to rearrange them so that I get all...

I have a workbook with 19 tabs(sheets). Each tab has the same column headings but the data is different. I want to create a summary page which would list the name of each tab and unique count of data in column E of each tab. The summary page would look something like this: <tbody> Tab name...

I am trying to use a formula to obtain a count of the number of distinct values in a list of data I have. I can use the follow: =sum(1/countif(ID_Range,ID_Range)) And it returns the correct number of distinct IDs in the range. However, I need to expand my number of criteria to something such...

Like the title. I was having trouble grouping after checking the box to add data to Data Model (I wanted to use the Distinct Count not regular count), and came on this article and comment that said it wasn't possible to group in your pivot table if this box was checked...

Hi all, Is there any way I can create a Countif formula where I can count a distinct ID once where the criteria would be that the criteria range only has one exact value? For example in this case, I'm trying to create a countif for distinct ID's where the sub_category would be "a" only. Since...

I have a sheet that looks something like this: A B 1 15 1 10 1 5 2 1 2 3 2 0 I want my result to look like: A B C D 1 15 1 20 1 10 2 9 1 5 2...

Please see the spreadsheet below. I've tried multiple array formulas with combination of sum/sumproduct/if/countif and no luck. I am trying to count the number of distinct ANI's that have a call time of greater than 0:00:29 and are of the campaign, Inbound - Live TV5. I've been at this for...

Hello Everyone, Im trying too understand whats happening with a small oddity when creating a Unique Distinct list. So in Column 'C' I have list of names with duplicates and in the column 'G' I have a Unique Distinct List created using the red formula at the top. Ive extended the Array beyond...

I have the code to create a pivot table from my data set however I'm not sure how to include the data in the data model (which is an option you see when clicking on "PivotTable" from the Insert Tab. My goal is to have a Distinct Count of my variable that I'm using in the Values data field...

I am looking for a formula that will assist in the last two columns -the first two columns is the raw data -the third and fourth columns is a distinct for the class name and a sumproduct -the last two is an Index/match/large I am looking for an all in one formula and haven't gotten any. I...

I have about 100 values in column some of which are the same and want to retrieve the smallest difference between any of the values in the list. For the example of the list of numbers below I would like to retrieve the answer = 0.04 <colgroup><col></colgroup><tbody> 15.03 15.11 15.22...

Hi, I have a problem with Excel and I'm writing hoping you can help me. I have Excel 2010 (with Excel 2013 problem seems to be resolved), with a large table of data, and a pivot on this table. This pivot contains page fields, and in value fields I have to count infos of a column "NDC". But I...

hi all I have recently upgraded to excel 2013 from 2010 and I have set up some new pivot tables using the data model function so I can count distinct items. However what I want to know is if I open a report created in 2010 can I then use the count distinct function? I can't seem to get it to...

Hello - for simple use by other users, I'm limited to standard Excel 2010 functionality. I'm trying to do a count of A, where sum of C by unique B are >0. This would be the first step of a much bigger CountIFS. HELP! <colgroup><col><col><col><col><col><col span="2"></colgroup><tbody> A B C...

Goodday, I want to use the SUMX function in combination with DISTINCT (PowerPivot + Excel 2010). For example I have this data: <tbody> Productgroup Product Sales Group Y product1 5 Group Y product2 4 Group X product1 5 Group X product3 3 </tbody> Products can be assigned to multiple...

Using a very helpful method found here: http://www.contextures.com/pivottablecountunique.html#download I've successfully obtained 'distinct' value counts in Excel 2010 by making a Pivot Table of another Pivot Table. The final Pivot Table's Row Labels are 30-minute increments of time (8:00, 8:30...