unique

I want to create a list with data validation taking unique values of the column #date of a table

Please see below example table. Column A has random numbers between 1 to 100 Column B has the following formula copied down starting from B2: =IF(COUNTIF($A$2:A2,A2)=1,1,0) I would like to get value of 1 in column B if the row in column A is distinct, else 0. This works well only for small...

Hi, I am trying to create a VBA macro that will generate outlook emails based on unique information in the cells. Every email is different and is going to different people. I need it to be able to generate numerous emails at a time without having to rerun the script. My file is set up so that...

hi friends! i'm using filter formula to build my list in column A. I have example of the formula in column D. what i am attempting to do is create a column like C where the duplicates are removed, only leaving the first occurring number. ideally I would like to wrap this formula around the...

Hi, Can I count the first instance of a duplicate value with multiple criteria? Based on below table we have the following: - 3 unique companies - 3 unique PO's - 12 items across 3 PO's Based on below table I want the following: - Cell B2: This cell should reflect the amount of PO...

Hi, could you please someone correct the below mentioned formula, as i am looking to extract a unique list from various sheets by using unique and indirect function and it is returns result as #VALUE! =TRANSPOSE(SORT(UNIQUE(INDIRECT("'"&{"Sheet1","Sheet2","Sheet3"}&"'!A4:A37")))) Thanks for...

I build a simple spreadsheet to keep track of the job numbers I work on through the day. In order to get paid, these job numbers have a corresponding SR number that I am pulling from a table. Some jobs may not have a SR number, so those need to be requested. I made a simple formula that should...

Hello All, Hope you are doing Fine. I have Excel data as shown in the below table. Can anyone help me to get the desired output? SCENE NUMBER CHARACTER NAME E01 SC 01 MICHAEL E01 SC 01 JACK E01 SC 01 ELIZABETH E01 SC 02 JOHN E01 SC 02 MICHAEL E01 SC 03 JACK E01 SC 03...

Hey all!! I have a unique problem... pardon the pun haha. I have a really simple equation =IFERROR(UNIQUE('Lims Report'!D7:D5000,FALSE,FALSE),"") This formula has always worked for a simple list with no duplicates, and now I have a list using this formula that has given me a duplicate :( Has...

Hi, Here is required a formula assistance to make a sorted A to Z unique distinct values in Start from column A:12, as based on data values extracted from column A:3 to D:9. Sample enclosed for your reference. Thanks for the help...

Hi, Required a formula help for generate a unique numbers of sales list as a sequence to be smallest to largest unique numbers without blanks as based on data contains in column A:G. Sample are enclosed, Thanks for help, ABCDEFGHI1Total Sales Units21015101410Return unique numbes...

HI Friends , I'm looking for a little help in Vba macro. I have two sheets ( category ) which has values like CURRENT ASSETS ,NON CURRENT ASSETS, CURRENT LIABILITIES ,NON CURRENT LIABILITIES , PROFIT LOSS Etc.. in the other sheet (Balance sheet) in column A i have CURRENT ASSETS ,NON...

Good Afternoon, I am having some issues with a dataset that came from an outdated system our business used before I joined, they had recently moved to a new system when I joined and now I can see why! The data below relates to Customer Journeys, which lack a vehicle identifiable field (which...

I have a spreadsheet of thousands of books that need to be broken down into groups of 5 titles. I want to know how many unique groups can be created from this list. The catch is, some titles have 600 copies, while some have only 1. How can Excel create my groups of books? Also, do I have any...

I have a workbook with multiple sheets (a new sheet is created every day). Column A of each sheet has product codes that are highlighted red yellow green or no formatting. I'm trying to create a worksheet that will show me the counts of each unique code. Can anyone help? Thank you!

https://www.dropbox.com/s/12n3dt7pcchg1zf/unrealized%20cap%20gain%20loss%20finder%20project.xlsx?dl=0 ^ This is an example of the data I'm using. In reality, Sheet1 is ~30,000 Rows deep, and Sheet2 is ~800 Rows deep. What I'm trying to accomplish: Table1 (in Sheet1) is the raw data showing...

Hi I've been given a set of data where I need to get a list of unique users from data where the usernames are repeated multiple times. A Pivot table will count the number of rows that each data set has, but not the unique number of users. There are 4 criteria that need to be met for a user...

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

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

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