1. G

    Populate Access ListBox with Distinct/Unique Values

    I'm a CS student in my 4th year, my professor wont grade my assignment because i didn't populate a ListBox correctly (I got a 10/200 but i have an option to turn in 1 revision). The ListBox named "lstCateName" displays a property type (castle, villa, manor) from a table named "tblProperty" on a...
  2. E

    Return unique values based on multiple conditions and sorted by date

    Hello, I have data similar to whats shown in the "Orig Data' table. I would like to pull unique Names only, based on two criteria (Start Date <= today AND End Date >= today. I would also like the data sorted (oldest to newest) based on the Name's corresponding End Date . My goal is to have a...
  3. J

    counting, ignoring multiple words and blanks

    I need formulas that will count unique occurrences, certain words while Ignoring blank cells and duplicates. I am trying to achieve the results in cells D8 and D9. In this case, I need to count occurrences that starts with W81UTH excluding duplicates and blank cells. I also need to count ALL...
  4. J

    Formula for Unique Occurence using multiple columns

    I am trying to achieved the desired results on E4. I'm looking for a formula that will count a unique occurrence specific to a date, ignoring duplicates and blanks. In this case, 19NOV19 has 2 trucks. 20NOV19 has 3 trucks. 21NOV19 has 2 trucks.
  5. J

    Formula help, counting unique occurences.

    I am looking for a formula that will count unique occurrences that start with W81UTH, ignoring duplicates and blank cells. Also looking for a formula that will count unique occurrences that does NOT start with W81UTH, ignoring duplicates and blank cells. I want to achieve the desired results...
  6. H

    Getting Unique Values from List without VBA

    Hi, I'm using Excel (Microsoft 365 on a Mac) I'm using the formula =IFERROR(INDEX($B$2:$B$9, MATCH(0,COUNTIF($D$1:D1, $B$2:$B$9), 0)),"") B1 = Fruit, B2 etc = Apple, Orange, Apple, Banana, Banana, Apple, Pineapple, Peach D1 = Unique, D2 has the above formula I copied the example from...
  7. B

    Count unique number in column B for specified month.

    Hi All, I'm wondering if someone could help me on this! Is it possible to add month instead of range. Like count unique number in column B for the month of Sep, Oct or Nov. Note that I have column C which has dated when claim number was issued. A B Test-Count | Auto-Num...
  8. J

    Output first Match Found if Cells contain Duplicate Text

    Suppose I have several a range of cells, each cell of which contain a string, and I want a function to look at this range and output "FALSE" if all strings in the range are unique from each other and I want it to output the first duplicate it finds if there are at least two cells with the same...
  9. 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
  10. 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...
  11. 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...
  12. 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.
  13. D

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

Some videos you may like

This Week's Hot Topics