unique cells

Hey, so i have an issue with some data. I have two tabs in the same excel. On TAB 2 in A column, i need it to find data in column I of TAB 1 but only IF a value appears in column F of TAB 1. I also need this to pull only 1 value per cell and not to pull duplicate values if possible. Does...

I was hoping for a code that will compare 1000s of entries in column A between sheet 1 and sheet 2 - and then extract the rows of those unique values in column A onto a new sheet (sheet 3) See below from example - Sheet1 1 QWE DOG QWE DOG 2 ASD CAT ASD CAT 3 ZXC MOUSE ZXC MOUSE...

I have some issues to solve a formula to count unique values in Column A:A from a date (Cell G2/H2) and forward with the two separate criterias (Cell G1/H1) in Column L:L. The purpose is to know when the setpoint of 30 loads is met, which means that it is time for the operator to change the...

VBA newbie here. I'm starting with a single workbook that has 2 sheets. With this, I'm trying to figure out code that would accomplish the following on execution: Create an Array with n elements, where n is the number of Unique Strings found within the Cells in Column B (excluding B1 and...

Hi, I have a file which has ~10K rows of data. I want to create a Pivot table removing duplicated values based on the name column this gives me ~2k but I want to capture the data that is derived in a column that contains a tag. The problem is that when the tag is generated there are many...

I am trying to find a way to identify unique numbers in the rate column for each ID number if it has Units. For example: In this instance, I would not need to identify anything for the first ID because even though there are units all of the rates are the same but the second ID has one rate...

Good afternoon, I have a long list of Windows versions from around 10,000 machines in my environment. I am trying to get a unique list of the values to print on another sheet. Obviously I can use the =UNIQUE(Range) formula when I am using office 365, but I am trying to get the formula so that...

Hello All! I'm trying to create a formula that counts the number of unique dates within a date range based on the type of item. I've tried several different formulas and researched ways to do it, but each formula was so specific to the poster's specific problem, that it did not work so I...

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

Well, upfront, I have a very basic knowledge of excel software and I hope my question isn’t too lame… Having said that, I have multiple storage boxes which I need to organize. Each box holds 100 units in defined fixed positions (1-100). Units have a very dynamic range of names (#ID) and also a...

I'm wanting to count unique alphanumeric value from column 'user ID', but I'm wanting to include a criteria of date range where column 'Date' is between 12/12/2019 - 18/12/2019. I've tried numerous array formula's but they're all too slow so i'm wanting to know if it's possible to do it without...

Team, I have a spreadsheet with around 500 values in each column. I am looking to discovery how to determine all unique values in the entire range. (If a values is in column B then it can be no where else in column B or C). I have researched and found examples of determining unique values in a...

A while back, I received some phenomenal help from Nishant94 regarding a complex formula I was trying to build to capture unique number of overlap days based upon some criteria. The original thread is here: Count Number of Unique Overlap Days - Meeting Criteria The formula (CSE) is this...

I am trying to create a list of unique values that relate to another list of unique values. Column A has a list of managers and column B has a list of supervisors that report to the manager in column A. There will be multiple supervisors that report to a mange, but no 1 supervisor will report...

Hello! I’m trying to find a formula for an Excel 2010 workbook that will identify the number of unique ids in one column that meet a condition in a second column then returns a count of 1 in the cell for the first instance then 0 for each recurring instance. Ultimately the count columns will be...

Hello, I'm trying to calculate how to count unique values based on a column set. I only want to produce what's in column 2, and have the rest of the cells be blank. Please see below as an example: <tbody> Unique Identifier Unique Value 100 100 100 101 101 101 101 </tbody>...

I have an existing named range called 'MyRange' which is dynamic. I'd like to get a new named range using vba of all unique values in 'MyRange'. I'd prefer not to have the unique values listed anywhere in my spreadsheet. Here is the code for the named range MyRange: With Sort k =...

Hello All, I work at a test lab and i have over 500,000 test records. I need to remove the duplicate record rows. The file has this layout. A patient can have multiple test and on rare cases have a different case number. <tbody> Case Number Patient Name Test Patient ID 1011 John Smith...

Hi! I know there have been a lot of threads for finding the unique values using macro but my problem is unique in its own way. I need to compare 2 columns from two sheets of the same workbook and find the unique value. The data that I need is from Sheet 2 column C. Sheet1 Column B has a lot...

Hello, I've tried searching for a solution, but to no avail. Below is a sales report of some Nike sneakers. Product is the item down to size level. Master is the Option Count. For example, a t-shirt, 400280 comes in 3 sizes, S, M and L. Hence why product is 400280-001 (small), 002 (medium)...