Hello, how would I count the unique in a range like this and extract them in to a vertical list please...?
Excel WorkbookBCDE2Plum3PlumWatermelonApplePeach4MelonKiwifruitBlackberry5RaspberryBlueberryCranberryBananaSheet1
Here's the link to a sample spreadsheet I made:
https://drive.google.com/open?id=1cQJvncI9xsAsrTicUA4Ql-MnZI2pwW_d
Essentially, I want the macro to go to the "Final" tab
-filter for each unique security ID
-insert a new sheet and name it that security ID
-and copy and paste that info into...
Hi All,
- My source data is Sheet2 Columns A-C
- My destination is Sheet1 Columns A-C
I need to perform two functions:
- Find unique values in Sheet2 Column B against Sheet1 Column B. Copy unique rows Columns A-C into next blank row in Sheet1 Column A.
- Find unique values in Sheet1 Column B...
so in column D, i have unique and duplicates, but i want a macro that deletes the unique values and thus leaving only the duplicates.
the data set, just fyi, is from column A to K.
Hi Experts, Could you help me with formulas to index data where there are duplicates in multiple columns?
I am trying to find counts of all unique records and tabulate it.
Here is a sample of the data to be indexed. The found records are UID from a CRM.
<style type="text/css"><!--td {border...
I have list of unique VINS.
I also have a list of 35 parts that belong to each VIN.
I need to combine these list so that i have A VIN, then 35 parts, then ANOTHER VIN with the same 35 parts, then a 3rd VIN, etc.
Seems like it should be easy . . . but stuck.
A macro would be nice . . . but...
Hello:
Is there a formula that can count only the visible and unique values in a column, based on criteria from another column?
This array formula I have counts the unique values with criteria, but it ignores filters and counts non-visible cells...
Hi, I have a spreadsheet which contains a list of 70,000 numeric codes in column B. Some of the codes are duplicated multiple times.
Is there a formula that will count the number of unique codes?
Thanks
Hello all
I am trying to use a countifs statement to count the number of lines that match a date but i want to also include only unique lines.
[=COUNTIFS(Data!Q:Q,C6)]
This is the countifs statement in cell "E6"
I also want to add the unique count to this formula which is in [Data!V:V] which...
Hi,
I have a sheet with 15000 rows and in column AV-CK have values which can contain duplicates.
I'm trying to get in CL the unique values from AV-CK (merged / concatenated)
Everything I've found so far (advanced filter, autofilter, remove duplicates) work on a range of values in one...
Hello
So I have manged to find a formula to help produce a list of unique names based on rules, but i can only get it to return the first name from the whole list.
{=IFERROR(INDEX(Master!$B$2:$B$500,MATCH(0,COUNTIF(H$2,IF(Master!A$2:A$500=H$2,Master!B$2:B$500,H$2)),0)),"")}
"Master B" is the...
Help please...I want to count the number of unique values in Column B (delivery postcode) where column I is a specific value (delivery depot) eg how many postcodes did a specific depot deliver to.
I've tried multiple variations of countif, frequency, match etc but can't seem to get it right :(...
Hi,
I have some data which is not in a format which is useful for what I need it for
I do not want to manipulate the 'Raw' data in anyway, a I need to keep an audit trail. I do not wish to use a pivot table function, as I need to be able to drop new data into the 'Raw' data tab and an update...
Hi, I'm trying to use SQL within VBA to calculate several related things at once, but I'm doing something wrong
I have 4 columns I'm interested in: ID, Description, Value and Date (see code for exact labels). I want to return a dataset that contains
- unique ID
- unique Description
- sum of all...
I need help to design a formula in excel to develop a unique random code, for example I have "Received" word in A1 cell then I want to get a unique Code in B1 cell, code should capture “R” from A1 cell then contain today’s current date like 011019 (01 day, 10 month, 19 year) then capture any...
I needhelp to design a formula in excel to develop a unique random code, forexample I have "Received" word in A1 cell then I want to get acode in B1 cell, code should capture R from A1 cell then contain todays currentdate 011019 (01 day, 10 month, 19 year) then capture any random numerical...
Hi All,
I have a range of data a1:a10000.
In this range there are duplicate values, unique values, blanks and zeros. I am looking for a formula that I can copy fill from B1 that will list only unique values, whilst excluding zeros and blanks.
A1 = Book
A2 = Book
A3 =
A4 = 0
A5 = Toy
A6 =...
Hello everyone! I have something I am working on but its driving me a little bats at the moment and I am hoping someone can help.
I have a spreadsheet with two columns. Each column has a list of keywords in it. I am trying to compare column 2 against column 1 and place the unique keywords into...
Hello folks,
I have an array of say (s,e,se,sw,s,n,ne,ne,s,e,se) and would like the count of the unique items in that array using VBA. 7 in this example I believe.
Is this possible and how would it be done?
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.