unique values

  1. R

    Can we Build a Paste Special Menu Button to Paste 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...
  2. adaytay

    Get Top 5 values in a list containing Duplicates

    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...
  3. E

    Extract unique values in a row excel

    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...
  4. L

    Copy Unique Values to a New Sheet

    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...
  5. C

    IMPOSSIBLE: Search and retrieve to new sheet based on adjacent merged cell value

    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...
  6. Q

    SUIMIFS only unique values

    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...
  7. R

    Table data depending drop-down lists

    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...
  8. M

    Combine 2 lists into 1 w/ no duplicates. Formula/function only.

    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...
  9. P

    Finding Unique Numbers within a list of notes

    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...
  10. I

    Trying to write AVERAGEIF formula with FREQUENCY for unique values

    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...
  11. I

    Excel Formula: Creater Unique Values using 1st 6-bytes for text

    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...
  12. N

    Count unique values in a list (some delimited)

    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
  13. L

    Unique values in Range & sum of unique values

    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...
  14. Y

    Returning Specific Values based on multiple criteria

    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...
  15. J

    Auto-Extracting Unique Values from a Data Extract

    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...
  16. H

    Extract unique dates given a criteria

    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...
  17. L

    Count unique values within a hourly time range

    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...
  18. M

    Advanced Filters 101....I think

    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...
  19. Z

    Creating 2 lists by extracting unique values but values in each list are based off each other

    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...
  20. A

    How do I count unique values in pivot table Excel 2010

    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"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top