distinct

I am having trouble figuring this out. I have a SELECT DISTINCT query, which is working fine. In the table that the query is based on, there is a Date Column. I would like to add BETWEEN DATE RANGE criteria to this query, but I have been unable to do so. If I add the date column to the query...

Hi Experts, Would need to have output as shown below. I am trying to figure out the right formula to be applied in Col "Output" to return value of ColB (those match in namedrange Members) when it finds first time match based on same value in ColA and the earliest datetime in ColC. For example...

Hi, I'm using the trusted =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,0,1) formula but with large amounts of data, it's absolutely crushing system performance. I'm using the formula in a helper column of a source table to populate a column in a Pivot. This is in Excel 2010. Is there a VBA...

Hi all, Due to a corrupt worker_ID table which I don't have write rights to, I get cartesian product on my query table below: workhours_id Date Amount worker_ID Productive 27567 05.07.2014 8,78 sein01 TRUE 27567 05.07.2014 8,78 sein01 FALSE 27568 05.07.2014...

Hello, I am looking for a formula that will return the distinct values of a list based on a criteria. For example...the formula would go into cell D4, and it would return the distinct "Item Names" in column B based on the "Group" in column A. Any ideas? Thanks! Mike

Hey hey hey This has had me flustered for nearly the whole day and I'm at my wits' end. A table has multiple 'titleids' (just a number column), with some different dates and some the same (so you could see the same titleid for twice on the 1st Jan, once on the 2nd Jan, once on the 5th Jan) I...

Is it possible to have a formula that generate a Unique list (List 1 and List 2) of Missing values in List 2 by comparing two lists? Something like this List 1 List 2 Missing in List 2 1 1 3 3 4...

Hi, I have functions: =SUMPRODUCT(1-(Id=""),--(SEC=A2)) it's posible somehow to use here distinct in def.range called "Id" ? because I want sum distinct ID I know that I can use pivot, but if is posisble please help me.

Hello Not sure exactly how to go about this, but have googled it to death in multiple ways, even googled the bits separately and can't figure out how to join them together. For my VBA, it needs a recordset, currently loaded manually (export file from Oracle, loop through cells adding to...

Trying to query a call list to pull people who haven't been contacted since a certain date. So if my date is 10/10/2012, I want all people who's last contact was 10/10, 10/1, et al. I do not want to see people who were called by 10/10 but have been contacted since. Likewise, if multiple calls...

Hi seniors! I have a big excel file with alot of data in it. area where i need help will be in counting the distinct number of project numbers. as in, if there are more than 2 cases where the project numbers are same, then i should count them as 1 and not separately. please help! :eeek:

Hi everyone, after a long search, on the forum and on the rest of the web, i couldn't find my answer, so i'm asking you now. I have a table (excel spreadsheet), which size is variable. Two columns are valuable to me right now, "TBF" (which is a number), and "Channel" (which has 7 different...

Hi everyone, I'm trying to create a series of dependant drop down selections (using data validation). I can get a single drop down working by creating a single-column table of the values, then referencing the table[#data] in a namedRange, which is then referenced in the data validation (list)...

Hello XL2007 I think the best way to explain what I'm trying to achieve is with an explanation... I'd like to, with the following data; Apple - Good Apple - Good Banana - Bad Banana - Bad Banana - Bad Banana - Bad Orange - Good Carrot - Good Carrot - Good Carrot - Good Carrot - Good Carrot -...

I have three columns of text and numbers and blanks that I need to extract a unique distinct list from with no errors and sorted if possible. Everything I have tried ends up with a zero in the list. Help :(

Is there an easy/quick way to select only distinct values from an array in VBA (I'm using Excel 2007)? I'm hoping there's an existing method for doing this, but maybe you have to do it old school and step through the entire array, compare each, etc?? Thanks, Mitch

Hi all, First posting on here and I would really appreciate your help. I have a list of data with repeated values stored in a dynamic range. The range needs to be dynamic because the range may increase later and there may be new values introduced. I want to use a data validation drop down...

Hi all, I need to do some macro to search in a collumn for distinct occurences of values . And then count to each one the number of occurences. Here is an example of what i need . occ |distinct occ | nr occ A A 5 A B 4 A C 2 B...

I have the following formula that counts distinct alphanumeric records (Sheet2 column A) based on a store (store is column B). The formula works correctly but because there are so many records it takes forever to process. Is there a more efficient/faster way to do this...