unique values

  1. T

    Multi Column Data Validation in Excel Table

    Hi Everyone, I have an Excel table. I am trying to perform a multi-column data validation. I am trying to use the COUNTIFS function like so: =COUNTIFS([Supplier],C2,[Supplier_Code],D2)<=1 The goal is to ensure that the data entered is not a duplicate. The combination of [Supplier] and...
  2. A

    Find unique values

    Hello everybody I am facing a problem and I hope you can help، I have two lists in two different columns and I want to have the unique values in a separate column. Is there any way? ABC1List 1List 2Unique2Andrew CenciniMichael Neipper3Jan KotasNancy Freehafer4Mariya SergienkoMariya...
  3. E

    Extract unique data from column and associate data

    Hello, i need a VBA code that will extract the unique values from column A and associate it's data from column B So far i only managed to extract unique data from col A into an Array. Thanks.
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. Navi_G

    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...
  14. 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...
  15. 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...
  16. 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 ...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

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
Top