unique combination

Hi Guys, I am struggling to get the unique agent counts for the data set I have. Need your help The table contains week number, agent name and survey outcome. I want to know unique count of agents who have error free outcome. As you can see from the data an agent can have possible outcomes as...

Hi, I checked the forum but couldn't find anything that worked for me. The problem I have is getting excel to count only the unique combination Part and Location, in the example below it should return the number 2 (colomn D) as there are 2 unique locations for the combination. <tbody> COLOMN...

Hi, I was hoping to find a way to identify unique values across two sheets in excel. However I want to do this with four columns grouped together, so it would compare four columns in sheet 1 against four columns in sheet 2 to discover if it is a unique value within the entirety of the list. This...

I have two columns of data, one contains a unique identifier, the other contains another 4 digit key. What I want to do is for the unique identifier when there is more than one 4 digit key that is associated to it, I would like to to display x. Marking both entries not just the first or...

Hi all, I have a problem trying to sum a range, should be quite simple but can't wrap my head around it. So in the table below: I would like to sum all the unique values within each branch, so for example for branch 123456 the answer I am looking for would be 2 and for branch 234567 I would...

So, I have excel 2007 and data similar to the below. Each ID represents a case file and the color a type of error (green is no errors), so there may be more than one on the same case: <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> ID Name Colour 12345...

Hi all Hope you can help me with this one: I have a list A with data. List A: <tbody> ID-nr Address Meters User Comment 1 Street A 123.4 Marc OK 2 Street B 56.7 Rob Problem </tbody> Now I got a new list B with more data. They have the same columns, same data, only the...

Hi I have seen to many combination solutions but none of them uses array formula. Is it possible to generate unique combination (order doesn’t matter) using array formula. Column A has list of participant, column C should give all possible unique combination. This is what I want: <tbody>...

To all of you VBA experts out there, I have a couple of excel tasks (n factorial) that might perhaps be fairly simple to do with VBA: task 2 is the ideal but task1 will be fine as well. So I have 3 columns, and each column has 2 or more items in them. Task 1: How can I create a unique...