unique values

I do a lot of filtering for lots of different spreadsheets. One thing I do about 100 times a day is copy-paste unique values from a column using the typical "Data->Sort & Filter->Advanced->Copy Unique Filters to Cell ___" So that requires a lot of clicking. I can't create a macro that does it...

Hey guys. It's been a while! As I've spent the last few years in Access and SQL land, I've gotten a bit rusty in some areas of Excel, and this is bugging me - am trying to do something which should be straight-forward, but is turning into a head-scratcher! I have a risk matrix, which has a...

I am trying to extract unique values from a row in Excel and I am not sure how to do this. It should not be complicated. Unique values in a column is pretty simple. I am not sure why it is so tricky to do the same in row. This is how the data looks. I am trying to extract unique values from...

I have a list of names in column A and data (not used for this step) in other columns on the first sheet. I need to copy the names from column A to the second sheet and I only want unique values. I cannot use the advanced filter (unless I am using it wrong) because I will continue to add names...

Hi, I may be asking the impossible or this may have been asked already if so apologies in advance. I am trying to create a macro that will search for all unique values within a sheet and list them on another sheet, by identifying the values based on the adjacent merged field. Additional I am...

Hi, I'm trying to add the values in column A based on certain criteria in other columns using a SUMIFS formula. However, some of the rows can be classed as duplicates for my purpose and I need to exclude them. IN the attached example, I need to add the length of the ducts in column A. However...

I have a file with several calculations, I have two pages I need to relate, in one I have data from several locations, and the other several options and Lifting Index calculation for scenario analysis. I want to include depending drop of lists on the second one, so user can only choose from...

I have 2 timesheet lists that are delivered monthly, and the length varies significantly each month. I need to form one list that shows all of the people from both lists... without duplicating if someone is on both lists. I have written a formula that works, with one little hiccup. There's a...

I am working with journal entries. I am trying to find the unique numbers in a cell that also contains words. I am unable to upload the excel spreadsheet due to it being financials. But I can give examples. Here is are some examples: 2000 carpet clean for makeready. repair planking 1884. 2N205...

Hello, I am using Excel 2010 and need to create a formula to show the monthly average for when talent lists are created for positions. The issue that I am having is that in the candidate database, the requisition number will show multiple times but I only want to calculate for each unique...

I have a list of project codes (pro001, katk002) however, the cell also contains a comment next to the project code. I need to create a unique list of project codes using only the first 6 characters. Example: Column A1 pro001 (comment1) pro007 (comment2) pro001 (comment) kat002 (comment) rdt005...

Hi, I hope this makes sense, but I need some VBA to count all of the unique items in a list such as: 1 2 3 4,5,6 3 2 1,2,3 As in, some cells will only contain one number but others will contain a number of them in a single cell. Any help would be greatly appreciated Thanks

In columns BQ,BT I'm using Index/Match to list Unique Values. These values determine hourly rates for regular hours (Columns BR,BU) and overtime hours(Columns BS,BV). How can I use excel to list the Unique Values in Column (BY) and the sum of regular hours for each value in (BZ) along with the...

I am trying to create an invoice of sorts using this spreadsheet: <tbody> Apply Type Credit Debit Credit Debit Total Credits that are charged Y charge a 5 40 15 25 Type Amount Y charge a 5 Y charge a 5 Y charge b 5 Y charge b 5 Y charge b 5...

I have been working through a project and have hit a bit of a snag. I have looked in the forum search but can’t locate an answer for this issue… The project that I have been working on takes raw data from a database and organizes it to summarize specific categories (salary, travel, materials...

I have a long list of dates (randomly given), and want to extract unique dates after 01.01.2000 from my list using a macro. So far I got this: Sub unikeVerdier() Dim d As Object, c As Variant, i As Long, lr As Long Set d = CreateObject("Scripting.Dictionary") lr = Cells(Rows.Count...

Hello, I need to count how many unique "operator codes" are active within certain intervals throughout the day. I do not want to use a pivot table. I've failed trying to adapt similar formulas for date ranges. Any ideas? Sample data is below. For example, for time range 7:00 to 8:00 AM...

I'm struggling with what I think should be simple. I'm using excel 2010. I have a data set with many columns, 2 of which i'm interested in. Let's say column A is "Department Name" and the Column B is "Product name". Both columns could change at any time (More depts could be added, and the...

Title may be a little confusing, I apologize. I have expense reports that contain multiple cost codes, job numbers, and expenses. What I want are 3 columns: a list of cost codes, a list of job numbers, and a $ total. I also want this list to e self propagating, meaning that I do not have to edit...

Is there a formula that will calculate unique values in a pivot table? I will need a formula that can be refreshed and automaticall capture changes on a weekly basis? I will need the count of unique customers by mgr email. I added a count on customer name and showed the value as "index"...