unique

  1. How_Do_I

    Unique in Range

    Hello, how would I count the unique in a range like this and extract them in to a vertical list please...? Excel WorkbookBCDE2Plum3PlumWatermelonApplePeach4MelonKiwifruitBlackberry5RaspberryBlueberryCranberryBananaSheet1
  2. D

    How to Simplify this Time Consuming Tax Via Macro

    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...
  3. H

    2 Sheets - Unique Values add and delete

    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...
  4. D

    delete unique values in column

    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.
  5. darrenmccoy

    Help to Index unique records in Multiple columns

    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...
  6. J

    Combine a single list of unique parts with a list of 35 components that belong to each part

    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...
  7. C

    Count Unique Visible Values with Criteria

    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...
  8. R

    Count number of unique codes in a column

    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
  9. V

    countifs and also unique value

    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...
  10. Grapez

    Extract unique values from multiple columns in one row

    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...
  11. M

    INDEX/VLOOKUP Forumla for Unique List

    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...
  12. T

    Count Unique Values

    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 :(...
  13. kweaver

    VBA: need unique values from a column

    In a worksheet (called Summary) I have values from G2 to Gn and I'd like column H from H2 to however long to be the unique values from G.
  14. H

    Combining data into a different format on a new tab

    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...
  15. baitmaster

    SQL calculating two different things from same data

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

    unique Code

    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...
  17. N

    unique code

    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 today’s currentdate 011019 (01 day, 10 month, 19 year) then capture any random numerical...
  18. M

    How to extract and list unique values from a range excluding blanks and zeros

    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 =...
  19. J

    Duplicates between 2 rows

    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...
  20. Z

    arrays count unique items?

    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'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
Back
Top