unique value

Hello- I have a file that changes monthly that I need to utilize vba to filter all unique values (that will change every month) in column D and add up values for each unique value from column L. Any help would be appreciated! Below is a sample of what it looks like. The dates change monthly.

Hello! A set of data was gathered where it consists of name of certifications and those who have completed such certifications. Required certifications (certs to shorten) needs to have a 'Yes' filled out . What I'm trying to figure out is returning a list of what certs that are required against...

Hi all, I'm having an Excel and I want to create a list of all unique values in Column A and B and copy them to a new sheet. This is my current Excel: This is my code: Sub CreateUniqueList() Dim lastrow As Long Dim ws As String ws = ActiveSheet.Name Sheets.Add.Name = "mysheet"...

Hi all, Hopefully an easy one In the below table, if a cell in named_range_2 has a number, I would like to return the corresponding value in named_range_1. I am working with a datasets with 1000's of rows if that makes a difference named_range_1 named_range_2 def 123 ghi hjk lmn...

Hi all, I'm using the following subroutine to stitch values from sheet "Stitch" col E to sheet "Sheet 1" col O If it is a match, we then copy data from col F & G into col L & K onto Sheet 1. This works if I have ONE match for each value in col E on "Stitch". But after using it for a while I...

Input: Column1 A;1;C;A A;X;Z;3 Output: Unique of Column 1 A 1 C X Z 3

Hi, Example of my 200k row data: ABCDE1TimeA21:00:00.0001.52:00531:30:00.0001.542:00:00.0001.252:01:00.0001.262:45:00.0001.372:50:00.0001.382:55:00.0001.592:59:00.0001.5102:59:08.0001.9112:59:59.0001.9122:59:59.0201.4133:00:00.0001.11422:00:00.0001.4A Column : Time B Column : Value D Column ...

I want to improve the formula for extracting unique zip code for 2019. I am currently using this formula but its very slowly: =IFERROR(INDEX('Project Data'!E:E;MATCH(0;COUNTIF('Dashboard Sales'!G114:$G$114;'Project Data'!E:E)+IF('Project Data'!L:L>=$E$113;1;0)+IF('Project...

Hi everyone. (NOTE: Due to company privacy policy, attaching file is BLOCKED by out IT Dept) I have to Worksheets. Worksheet 1 = Summary Worksheet 2 = Data What I want is to update Summary, for example starting at cell L47 down until L56 (all blank cells). I want to put values in there...

I have been struck in using multiple VBA coding, however not getting what I require. Hope someone will assist me in resolving my issue. There are certain entries that user is going to enter in excel in Column A, Column B, Column C, Column D and Column E. I require that user can update any value...

I need some vba code, that will return a list of unique non consecutive items from a table, when a certain value changes in one of the sheets. I have been trying with this formula, but I have had no luck. =INDEX('Price List'!$A$3:$C$57000, SMALL(IF('Price Sheet'!$B$4='Price List'!$A$3:$A$57000...

Hi guys, I've searched high and low for a solution to my specific problem, but to no avail. Hence this post. I am developing an Excel database of drivers and the trucks they drove. These entries are being made via a userform throughout the month as they use the truck. The basic table as...

Hello expert Excel users! Below i will describe what is the purpose of my first forum post, so bear with me. So i have multiple tabs defined as tables in a big excel file. Each table has one or more columns but then, some of the tables do have common fields among them. What i want to do is...

Hi there, I'm wanting to create a formula that retrieves a unique cell value if multiple criteria are met. E.g. If 'Interface'!H8 matches item in 'ReferenceList'!ColumnT3:T245 & 'Interface'!I8 matches item in 'ReferenceList'ColumnU3:U245 then show corresponding value in...

Help needed by anyone who can grant me some assistance. Here is what I am trying to accomplish with VBA. I have a workbook that contains 4 sheets - summary - rollup of campaign information from billing and impressions billing - campaign billing information impressions - campaign impression...

Hi All! I am having trouble with formulas. One formula i have wont work, and I need a creative formula. Columns A and B: I have a long list of values, some will be repeated up to three times, some wont be repeated at all. The number of values in the list will vary every tie I use the...

Good evening to all, It is very nice to meet you! I would like your help for a vba code to do the following: I have a workbook containing sheets A, B, C. All sheets have the column "Name" as their first column (there might be multiple lines with the same name). I would like to split the files...

Hello, I am looking for help with a formula to return a unique value once Excel has found a match. I will try and explain as best as I can. I have a column (Column A) in a master worksheet (Worksheet A) that compares two columns from two separate worksheets (Worksheet B and Worksheet C)...

I Have a names in excel a1 to a13, i want to Filter for unique values, after getting the unique values, i change the Name to correct format, when ever i change the 1st unique value, how to automatically change the duplicate Values. Corret Name : Balu, Raju, When Ever i Change a1 Ballu to...

Hi everyone. I've been racking my brain with this one for a while now and am hoping someone can help me to understand what change I need to make to return unique values. I have a workbook with two worksheets. One worksheet contains a list of every employee in my local organization, and in the...