Hello, I have looked all over but I don't seem to find an answer to my particular question.
I am trying to count unique client id values by month and by another criteria, in this case gender.
That title was quite the task to try to summarize.
I have an ever increasing amount of API keys I can call upon of which each one, obviouslly, has some rate limitting set out on it.
I am looking for a solution/ formula particularly, where I can pull an API key to utilize in my overal...
I tried this code to copy and paste unique values but 1st value comes twice.
Dim cell As Range, areaToTrim As Range
Set areaToTrim = ActiveWorkbook.ActiveSheet.Range(Selection.Address)
areaToTrim.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("I4"), Unique:=True
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...