unique

  1. B

    Create unique "id" from codes with different cases

    Hi all I have a large table including Salesforce Id's, which are supposed to be "unique", but unfortunately also use case to make them so. The table uses data that includes a range of Salesforce Id's, from just one, to many rows with the same id. I need a way to convert these id's into truly...
  2. apgmin

    list and count unique Excel 2013

    In column A, I have a list of values from A2-A503, I fill these cells In column B from Column B2 onwards I want to list the unique values from column A ( A2-A503 ) In column C from Column C2 onwards I want the nos. of repetitions of the unique values listed from B2 onwards PLEASE SEE THE...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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.
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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
  15. 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...
  16. 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...
  17. 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.
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top