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:
The goal is to ensure that the data entered is not a duplicate. The combination of [Supplier] and...
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...
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...
I'm looking to calculate on how many RNA issued in specified month. Please see my example below:
Thanks in advance!
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...
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:
If possible, also sort these...
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
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
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...
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...
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...
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...
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
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...
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...
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 ...
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?
Dim Lrow As Long, test As New Collection
Dim Value As Variant, temp() As...
Excel 2013 64 bit
FT014, FT015, FT016
1, 2, 3
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...