unique

Hello all, I need to produce a template for a table which shows me the number of distinct customers I have in each country each month. I have a list of global sales transactions with Country, Customer ID and Sales ID: • Each customer has a distinct Customer ID • Each customer may have...

I have been successfully using this formula: =UNIQUE(FILTER(pp_tasks,(wbs_Hire=1))) with great success to apply an auto filter to a set of unique values. In a certain use case, this data set is still too large and I only want it to return the first 200 values. This formula: = INDEX(...

Hello! I need to count unique values based on two criteria and this is the formula I've come up with. It successfully gets what I want, EXCEPT it returns a 1 when it should be returning a 0. I tried adding in an IFERROR function so that it doesn't count any #N/A's that the FILTER function...

I am measuring "population" for states/cities. I would like to get a list of top 3 states/cities in critical status based on population. The dataset I am using has metrics for years 1910-2017. Short example with made up data: A B C D E 1 State City Year Status Population 2 Pennsylvania...

I need a formula to get the result I manually typed in the last row. Smallest with no ties. Not the 2nd or more smallest.

Hello everyone! I have the following formula that extracts columns 1,2,3,6,7 from sheet1 into sheet2. =FILTER(INDEX(Sheet1!A:G,SEQUENCE(ROWS(Sheet1!A:G)),{1,2,3,6,7}),ISNUMBER(SEARCH(Sheet2!B2,Sheet1!F:F))) How can the formula be modified so that only unique records in sheet1:column2 are...

Hi all you wonderful people, I am trying to return a list of distinct items using the sort formula below. =SORT(UNIQUE(FILTER(sheet2!$P$2:$P$300,sheet2!$N$2:$N$300="Test1"))) This works perfectly, except I only want to return items where sheet 2 column N = “Test1” or “test2”. I am guessing...

I am trying to make a Data Validation list from one of my tables, but I can't seem to get the UNIQUE function to work in the Name Manager. If I create a new Name called "Sports" and use the formula =tblGear[Sport], it works just fine. However, I want the unique values from there. I don't want it...

HI All Hope you can help. I've got this formula below in a spreadsheet: =COUNTA(UNIQUE($M$2:$M$10231)) How do I update this to count the visible unique values in the same range? I've tried what I figured to be a logical solution (as 103 = counta) but it just throws up an error...

Hi Everyone, I have attached a spreadsheet and highlighted in yellow the column K I would need to be filled with a formula (spill formula only so that it is completely automated). Column I and J: This is a spill formula using Unique, Filter and Choose function. Column K: I would need a spill...

Hi Folks. Working with about 1000 rows of data, I have numeric values in column D not sorted but recurring at random intervals. Column A contains names. Those names can and will be repeated. I'm looking for a way to say if the cell in column D is equal to 000415 then count the unique text...

Hi Everyone, I have an issue with a formula and I have been told we have all the experts in the world to answer to this question. I am trying to get a list of unique values for 2 non-adjacent columns. I have tried the formula below but it doesn't work. It only spills the result for one single...

Please can someone tell me how I can amend this formula so that it returns all numbers in column F up to the last row, i.e. so that I can use it repeatedly on workbooks which have different rows of data. Sheets("Lists").Select Range("A2").Select ActiveCell.Formula2R1C1 = _...

I am currently working on an excel formula which give me a sorted array of unique items and their values. I have reconciled the steps in the following excel but couldnt crack it to one step. The difficulty is also higher due to the multiplication of two colomns (i.e. asset value & % ownership)...

Hi All, I have a maths question I need your help with. I'm trying to generate 12 unique pairs for Badminton Doubles to not have the following: Player 12 not playing Player 4 three times (example Game 4, Game 5 and Game 6) Player 5 not playing Player 7, 8 and 11 more than once such as 7,8...

Hi All, I have a three sheets, Sheet 1, Sheet 2, Sheet 3. Sheet 1 has Id's and email addresses columns, Each Id has many emails, sometimes blanks too,. Each Id has multiple rows in Sheet 1. Sheet 2 has list of keywords words to use as exclude lists for email addresses. Sheet 3 has Id's, and...

Hi, I have anywhere from 60-100 spreadsheets generated from a reporting process in a folder. Each spreadsheet has set number of columns (A through G). Column G (Notes) is used by end-users to put notes. I am working on creating a unique list of all these notes from all the spreadsheets in the...

Hi everyone, I'm searching the web but I only found one code that kind of works but I need to make it more complex. Let me explain. My issue is that I have an Excel sheet with multiple worksheets, which all contain the same kind of information but are copied weekly by me. So every week, I will...

Hello To All, Need Formula to generate and apply unique number for "Import" or "Purchase" to create a sequence series. For export i want to apply original unique number which i can find by index & match. Attaching Table for the reference. Thank you in advance...

My title might be confusing. So, here goes. I'm attempting to create a summary sheet of sorts for a weekly schedule. There are multiple tables throughout the workbook that represent days of the week and tasks for each day. View a portion of one of those tables in my "Thursday" tab below: I...