1. J

    Extract all delimited values from column into their own cells in new column

    Hi everyone, I have a spreadsheet containing email sender/recipient metadata (email from, to, cc, bcc) that I am attempting to normalize. Column A contains the email IDs, and column B contains the recipients values, delimited by semi-columns. Below is an example: Column A (Email ID) Column B...
  2. L

    How to return the starting balance of a bank account in a master list of bank accounts

    Hi everyone, I've built a workbook that evaluates a client's banking information and processes multiple bank accounts at a given time. I'd like to find a formula that will return the starting balance of each unique bank account from my dataset to reduce human error with data input. The...
  3. M

    Copy and paste only unique rows from one sheet to another after refreshing data.

    Good Afternoon, All. I have a workbook, CallLog, containing the following tabs--"Summary,"Data","MysteryCallLog2," and "Pivot." "Pivot" is merely derived from "Data," and used to visualize data in graphs and slicers on "Summary." "Data" contains the resulting information from a SharePoint...
  4. 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...
  5. 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...
  6. 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...
  7. 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.
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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
  13. 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...
  14. 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...
  15. 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.
  16. 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...
  17. 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...
  18. 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...
  19. 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
  20. 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...

Some videos you may like

This Week's Hot Topics