unique

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

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

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

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

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

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.

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

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

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

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

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