distinct values

To enhance visibility when looking through a list/column of slightly changing codes I want to make sure my eyes see when a code has changed, by coloring the distincts. I want to: run a macro that gives my selection of cells a (unique?) (random?) color for each distinct cell value. Anyone have...

Hello - I have two columns: Column A | Column B 6022 WF102 6022 WF102 6023 WF104 I am using index/match to fill Column B using look up values in Column A. My goal is to grab the next distinct value in Column B. There are multiple vendors with the same product code...

Apologies for the convoluted title but I couldn't think of a simpler way to put it without losing some fo the problem. Background: I have a sheet that populates two tables by running queries on an SQL database we operate from. It contains information relating to moving goods around a warehouse...

Hello all, I have a data set with about 200 columns and 10,000 rows. Here is a sample: ColA ColB ColC Apple 1 Fruit Apple 2 Fruit Cuke 1 Veg Cuke 8 Green The result set I would like is: ColA ColB ColC Apple 1 Fruit Cuke 2 Veg 8 Green I want...

Excel 2013 64 bit <tbody> A B C D E F G H I J K 1 ID FCM FP FCLMS SD AED LAD WAEM ABP Note Formula Script Formula 2 ABC FT014 FT014 1 3 DEF FT014 FT015 FT016 FT016 FT016 FT016 FT014, FT015, FT016 1, 2, 3 4 ZYX FT028 FT016 FT016 FT016 FT016...

Hello, I'm trying to have a SearchUserForm populate a combo box with non-duplicate unique values that is sorted alphabetically when the form is launched. The following code gives me the unique values in the combo box but the list is not sorted. Private Sub UserForm_Initialize() 'Empty...

I have a sumproduct formula that draws on named ranges like this: =sumproduct( (createdate>=b1)* (createdate<=b2)* (email)) b1 is 1/1/14 and b2 is 1/31/14 so I'm asking for all records created in January. But how do I ask for the count of DISTINCT email addresses? It's a pretty large data set...

I'm using this measure =COUNTROWS(DISTINCT(COLUMN)) to tell me the number of unique items completed per person in a pivot table. I've done some searching, but I can't figure out how, in the table, to get an average of those unique items over time (weeks, months). The table data does include the...

Hello, I've used this site and forum extensivly to solve issues for a dashboard I'm building, but can't find a good solution to the following: Creating a list of distinct values (removing all duplicates) when a condition is met. I know there are ways to do this with Index formulas, but my data...

Hey everybody, I already managed to almost solve my problem with putting together a rather long formula from existing threads but when it comes to those ranges I give up. I have a very large data set (30k rows, no blanks) and I am trying to count distinct account numbers based on two criteria...

Good morning, I have a report that is automatically refreshed everyday from my SalesForce addin to excel 2007. I have a pivot table that automatically refreshes based on the data in the master sheet (sf document). I also have another sheet that summarizes the information based on Managers that...