unique values

  1. M

    How to make every number in a range of cells unique???

    Hi, I have a large range of data - I need to use range formulas using If and Large combinations to return the largest number when certain conditions are met. As the dataset is large, there are duplicate values. As a workaround I add a very small number to every number in the range, to create...
  2. B

    Count number of unique values in specified date range:

    Hi I'm looking to calculate on how many RNA issued in specified month. Please see my example below: Thanks in advance! <tbody> Date RNA TOTAL 18/02/2019 3371 1 RNA 18/02/2019 3372 2 Month ISSUED 18/02/2019 3373 3 Feb 18 18/02/2019 3374 4 Mar 19 18/02/2019...
  3. G

    Filter Table Column, pull Results from another column into an array to filter out duplicates and paste on another sheet

    Greetings all, this is my first posting as I can't seem to find the answer despite some serious research. What I need to accomplish: 1. I have a table and I want to filter on Column 1 for a specific word (in this case Management) 2. Then I want to copy the filtered results from Column 5 - ONLY...
  4. L

    How to read values from Txt File as unique values

    Guys I have some values inside a txt file and I would like to "read them" importing them as unique values in my excel spreadsheet using VBA . The values are separated by comma: Apple, Beer Orange,Peach,Pineaple Wine Water, Peach,Wine Orange,Apple,Water etc. If possible, also sort these...
  5. 1

    Unique to clipboard

    I did find a most beautiful macro somewhere in the net making it possible for me to just make a selection and it would make the unique values in the selection go to the clipboard sorted It worked fine in Excel 2010 but stopped working in Excel 2014. I get no sensible output , just ￿￿ Could...
  6. M

    VBA - data validation drop down with unique values

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> -5down votefavorite I am looking at sales data and have 30000 lines of data. In column B is the name of "Product" sold. There are many duplicate values in this column...
  7. M

    Problem creating unique values to create a relationship

    Hi I'm trying to join two tables together through a relationship but am having trouble. My data is of a Building (type text) , which has Floors and Rooms which can both be a mix of text and number names (type any). In order to create a relationship based on the Room column, I attempted...
  8. P

    Count Unique Values

    Dear members, I am working as a Logistic consultant and optimizing processes is a big part of my job. I often have this issue that I need to count the number of unique values where I have a lot of data in. For example: I have 80.000 SKU's and 5.2000.000 orderliness a year, I like to find per...
  9. S

    Reference Unique Values in Table

    Hi, I'm trying to pull in the Employee Name based on a Manager's ID Number. For example, if I type in 1234 - I want the table below to fill out with all of her direct reports. But with Index Match, it only pulls in the first result. Is there a way to pull in the new next result and keep going...
  10. N

    Find Unique list updatable

    Hi, In Illustration i see duplicate and unique values. i want to make a Unique list with formula. other if possible to ignor duplicates Question Table Invioce No. Total 11760 $90.03 11105 $77.63 11173 $74.92 11871 $83.29 11334 $96.34 11908 $61.27 11961 $67.38 11105 $61.66 11334 $95.72...
  11. D

    Count/frequency of unique values based on TWO criteria sets

    I have a gargantuan list of orders by item for each customer: Customer A - Item Z - Q1 - Order 1 Customer A - Item Z Q2 - Order 2 Customer A - Item Y - Q5- Order 3 Customer B - Item Z - Q1- Order 4 Customer B - Item W- Q2- Order 5 Customer B - Item W- Q4- Order 6 I want the number of times...
  12. D

    Advanced Filter method out of range

    Hi guys, Im trying to pull out unique values from a column of a table and trying to paste it in a table of a different sheet. before I just copied the whole column and used remove duplicates, but that was taking a long time since there are a couple hundred thousand lines. then I tried the...
  13. B

    VBA / Find Dublicate Value's last row.

    Hello mrexcel family, I'm new one for this forum and I want to need your help. I want to find dublicate value's last rows and unique values then I want to write "use this row" second row with macro code. After that I will use this code in some userform design. For Example Data is ...
  14. V

    Populate form control Drop Down Box with unique value

    hi, I am trying to populate a drop down box with a column of dates and only want to populate unique values. I have tried the following code but it doesn't work. Can anyone please assist? Sub FilterUniqueData() Dim Lrow As Long, test As New Collection Dim Value As Variant, temp() As...
  15. M

    Extract Unique Values From a Row

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

    Two filters to select values and paste unique in another sheet

    I have data as below Currency Location CAD 00002 CAD 00004 CAD 00005 CAD 00002 USD 00001 USD 00002 CAD 00006 CAD 00004 CAD 00005 USD 00001 I want to filter for CAD, then select the Location...
  17. S

    Extract Unique Series Names and Add as Dummy Series

    Hello All, I've written some VBA which turns an array into a stacked bar chart where series with the same name are coloured the same. However, having multiple series with the same name has led to a rather pointless legend with multiple duplicates. My main two questions are: 1) Is there a way...
  18. J

    VBA - Unique Values Based on Condition

    Hi, I'm not very educated in VBA. My co-worker has created a Function Macro and I wanted to modify it to pull only unique values that have .pdf at the end. Would this be possible? Any info or help would be much appreciated! <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font...
  19. S

    Get unique values from a 2d range?

    Hi all, I'd like to extract a list of unique values from a 2D range. So, text values from A1 to D10, some repeat. And in another column vector are listed just the uniques. I browsed here, but they cover uniques from just one column, not a range: 3 Ways to extract unique values from a range in...
  20. R

    Summing up Unique Value across multiple worksheets

    Hi All! I need to sum up a person's allocations across multiple worksheets, 6 in total. Any Suggestions? For instance, How many hours is Jane Doe Allocated across each book.

Some videos you may like

This Week's Hot Topics