identifier

Lads, Need VBA code that compares 2 sheets (''Sheet1 & ''Sheet2'') in same workbook and looks for Identifier in Column B and deletes entire row on ''Sheet1'' if identifier not found in ''Sheet2'' also in Column B. If new identifier is found in ''Sheet2'' then it needs to insert row in...

Hello! I have a spreadsheet that others will use to correct data entries for a unique identifier (i.e., there is only one instance of that text string on a given sheet.) In short, the main spreadsheet imports data from different spreadsheets, and any incorrect unique identifiers must be...

Hi folks. I'm new to this board so please forgive any minor transgressions. I have tried searching for the answer but without success. I have two datasets: the first contains a large number of records each containing a unique identifier which relates to something happening between a start and...

I have a large one year dataset (around 20,000 rows) where there are two main columns, one is the unique identifier (duplicated), the other is the employee assigned to that unique identifier (unique). I am trying to develop a formula to count the number of unique employees assigned to each...

I have a list of dates 12/31/2017, 11/30/2017 etc. in column B going back in most cases 15 years on a rolling month end basis. I was able to use this formula to pull in the oldest date: MINA(INDEX('SQL Dump'!C:C,MATCH(Calcs!B3,'SQL Dump'!B:B,0))) This pulls in the oldest date for each...

I have a report that I am pulling from our database daily (Sheet 2). I am using this report to update information on a master spreadsheet (Sheet 1). Consider sheet 1 as a running total that is updated daily through a script and sheet 2 is information specific to today that I need to add onto...

I am trying to an identifier with data on multiple tabs to run a calculation, here is an example: Tab 1 = Data C Tab 2 = Data B Tab 3 = Data A = C * B Data on tabs 1 & 2 the data has cross tab identifier: ID 1 Data C ID 2 Data C ID 1 Data B ID 2 Data B On a summary tab I want to be able to...

I need to sum up a row of values but subtract certain pieces. So the values that I need to sum are in column "M", but I want to exclude values that have an identifier in column "J" between 700 and 799. I know how to write a sumifs formula but is there a way to say hey sum these values but...

Hi I have basic knowledge, using Excel 2010. I want to match/look up a cell value on one sheet with a unique identifier data on second sheet, and then populate on the first sheet 5 adjacent cells which are immediately to the right of the unique identifier on the second sheet. I have a lot rows...

Hi, I have a workbook-level double-click event that I put into a certain workbook awhile ago. It checks if there is a record identifier in a certain format either in the target cell or in the current range, within the double-clicked row; if so it queries an SQL server to find backup...

I have 2 databases. They are internet speed tests. The address table and the speedtest table don't have a unique identifier to link them together (whoops!), but they do have time stamps. I'd like to use the timestamps as a (sort of) identifier. How do I do a lookup that tests for...

I am trying to write A2= 456758 J2= 450.75 If A2 AND J2 in sheet1 MATCH with in Detail tab A2 AND J2 THEN "" ,"Missing" So A2 has a identifier that can repeat but j2 has the amount that relates to that identifier. So i am looking for 456758 and 450.75 in the detail tab. if it is there ""...

Hi, Not sure if im going to explain this correctly or over-complicating but hoping someone can help I have a macro that copies data into an excel from column A to D. In column B will be identifiers that will drive the formulas. (date might be needed but not sure) Example we copy in data from...

Ok, I have a large set of data and the values in the rows repeat themselves but they mean something different based on other factors. Here is a sample of what I am looking at: Loc Item 1 A 1 B 1 A 1 B 2 A 2 B 2 A 2 B 2 A So I want a different value assigned to the first row that has 1 and A...

HI, let me thank you in advance for any all suggestions and solutions! I have been working on this problem for a while now and cannot find a solution. I have an extensive workbook with 3000+ sites. Each site has information specific to that site. Latitude, Longitude, Site Identifier, etc...

Hello. I have to copy the column starting from row 3, which has the first value "invoice identifier" in the second file, where the second row has the value = invoice identifier. The number of rows is different each time Windows("template DHL-Duta Iulian .xlsx").Activate Windows("Anexa...

In the last 3 months I have been trying to get more familiar with Excel and every time I Google any question I may have it always brings me here and I almost always find what I'm looking for so thank you everyone that contributes to this site. I feel bad for asking since I'm a novice and don't...

Hello I need some help: I have a spread sheet with dozens of thousands of unique identifies (Subscriber IDs). Each one represents a person. Some people were billed for a coverage periods and some people's billing for a coverage period was skipped. Now I have to figure out which people...

Hello, I have been stuck on this project for weeks. There are six sheets. One named 'Macro' that will have instructions and command buttons, 'Results' where the data would populate, and APAR, MBS, Purchase, and Sales. So the common identifier is the CUSIP. Not all sheets will have the same...

Hi there, I have a column that contains non-numeric values (in some cases, repeated) - for example, software brands. Am I curious if there is a quick (1-step) way to assign numbers to each value in the column such that common elements will be assigned the same number. In other words, replace...