unique

Hi, I'm trying to figure out a way to count the unique number of values based on two criteria, where one criteria is dependent on a list (named range). =SUM(--(LEN(UNIQUE(FILTER(Table1[ID];(Table1[MONTH]=$S$1)*(Table1[VALUES]=NamedRange);"")))>0)) What would the best way be to count the...

Hello all, unfortunately I can't get XL2BB program to work, so I'll try to describe my issue. It is likely an easy fix but I just can't seem to wrap my head around it. LineValue LineValueUnique? FIBER DSL 029860000 COAX I/E-KUNDE 028020000X TASTET AF...

I've got a range of letters, and I want to calculate how many unique values occur in it, excluding the letter A and empty cells. I've used the formula =COUNTA(UNIQUE(FILTER(A1:A10,(A1:A10<>"A")*(A1:A10<>"")))) which works fine, except when the result should be zero. Here are some examples...

Hi, I'm trying to count unique IDs in a table with ID and Resource as two separate columns. In this case I need to count any resources that contain "land" in the resource name (can be anywhere in the resource name). I have been searching around and came across the UNIQUE and FILTER function for...

NTIMES returns the values that occur at the specified number of times with full control over data types(s) inclusion/exclusion/replacement (The code is modular (as all my other functions) allowing for easy reusing/swapping/optimizing over time. See all the modules below, after the description)...

Hi All, Extremely sorry that I was not able to upload excel sheet hence had to go with snapshot.. Can you look into it and help me with possible solution. How do I filter unique value and vlookup it in left table? Please advise.

Hi all, I have the input table from A1:G28. My goal is get to get the unique rows based on 3 columns (A, C and G). The output would be like the table in M1:O14. I was able to get this table manually joining the 3 columns I need, then Data/Remove duplicates for values in column I. I got unique...

Hi, I'm struggling to find a way to make some textjoin alike formula with IF condition and also "unique" too in order to combine results that share same value. I have something as per below example: ID Type Name1 Type1 Name1 Type2 Name2 Type2 Name3 Type1 Name4 Type1 Name4 Type1...

Hi All - Thanks in advance for looking at this - appreciated. I have two ranges of data on separate sheets - a1:a2500 on one sheet and a1:a7500 on another sheet - is it possible to combine a TOCOL and Unique formula that will return the unique values from both columns? Thanks - Mark.

Hi, and thank-you in advance for your assistance... Column 'A' contains a set of order numbers. These may be duplicated if a sales order has more than 1 product. Column 'B' has the date of sale in every row regardless of whether the order number is duplicated or not. So, i am trying really...

Hi, I am using the below formula though I need the results to skip 3 cells each time, therefore the results to appear in cells A1, D1, G1, J1 etc. =UNIQUE(TRANSPOSE(Data!I4:I13)) Can someone help please?

Hi, I was able to create a a data validation list by using UNIQUE, however, my rows may change whenever I update the template. Can anyone advise how can I change my current formula to consider the rows changes...

I am trying to do the following on a summary tab: 1. Perform a summary calculation of common part numbers 2. Display the total qty as a unique row displaying the total qty of the duplicate part numbers into col "A" on the "SUMMARY" TAB 2A. If all the rows of duplicate PN qty are 0 then omit...

Good Morning I wondering if its possible to create a formula that would split a cell by a comma and keep only the values that start with "TV -". Keep only unique values Take the data and insert a line feed between each grouped value before saving it to the column as shown in the...

Hi Experts This is the power of Excel - That you start to believe can I go 1 level further. Recently I had a thread - https://www.mrexcel.com/board/threads/filter-unique-values-out-of-a-multi-column-list.1251328/post-6140661 where @Eric W @ISY @Fluff gave me the solution. Due to my system...

Hi Experts, I wanted to get a one column list out a range. So far have been able to extract a multicolumn list. But I want it to be one column list so that it could be filtered further for unique values. Got kind of stuck somewhere. Please help Thanks in advance Underneath is the formula I...

I want to get a summary of the unique value under a condition. Like in the below table- 1. For article BD-01, the Sorted (A-Z) unique area code is 11, 12, 15. 2. Then for these Unique codes, there are some product codes. 3. Now I want to Join all Area code and their Product codes with separator...

Hi, required a formula help to return a correct results, the below stated formula returns a N/A error could you please rectify it...

hello i want to create list of random and unique numbers of 8 digits between 12345678 and 87654321 but any digit should not be repeat for example 12345678 ok 21345678 ok 32145678 ok 12245678 not ok. due to repeate of 2 87654321 ok 87754321 not ok due to repeat of 7 pls help

I am trying to use the FILTER formula to return only the results that meet a criteria listed on column B. On column A, I am using the UNIQUE function to bring unique values from a different table. Column B has 1/0 values related to the data on column A. In column C, I would like to have only the...