identifier

<tbody> XX_ID_A Site Name Manager 1 Fred 9 1 Mary 1 Jack 9 1 Jill XX_ID_B System Plan Fname Lname Man Note 1 TAD John Smith 6 Service 1 TAD Jerry Jones 6 HR 1 TAC Alan Berry 7 1 TAB Mary Dawson...

i need help creating a formula to do a lookup, on my landing page i have an identifier for a company, however on my data page there may be more than one record for that company that all have the same identifier with different start dates. i need a formula to bring in the last date associated...

I am looking for a recommendation on a formula or other option to best complete the following task. I have two data sheets that have different data but have a common identifier between the two, so my ask is to take the common identifier and to essentially merge the data from both sheets onto...

So I have 2 worksheets. Sheet 1 contains 425 rows and the last column being used is O currently. The first column contains a unique identifier number. Sheet 2 is used to send out mail merges it contains less rows until it is filled and the last column being used is S currently. Now in Sheet1...

Hi all, sorry I may not managed to correctly phrase my initial question... I have a Source Table with several columns (and hundreds of rows) from which "Code" and "Identifier" are causing troubles. In "Code" there is always a 2 digit number. (00, 01, 02 etc.) in "Identifier" there is always a 5...

Hi all, I'm a novice at excel and looking for someone with VBA experience to perhaps fill the gap. I have a workbook that has a unique identifier, a name, a date and a dependent dropdown menu (stage and status) for every row. I'm looking to keep in a separate spreadsheet an audit trail of...

This sounds like it should be simple, but I am struggling. Thank you in advance I have 2 columns of data similar to the below (but 44,000 rows). First column is an account number, second is an identifier. I need to identify the where an account number has both a 2 and 1...

I am trying to figure out a way to do dynamic correlation between variables by choosing start and end date, (Vertical Column A), and doing correlation between 2 different columns of values. The kicker is there is also a column of identifiers in Column B. So i'd like to select correlation between...

Hello (i have simplified my query a little) I have 4 sheets with data in rows, on each sheet in column A I have an identifier eg "X". My want is to have a VBA which will copy data from sheet 1, all rows with the X identifier to sheet 5 - with no spaces between rows. Then to look at sheet 2...

Hello all, and thank you for everyone's time in providing this valuable resource. I spend a lot of time manually sorting data that is pulled from a database and hope to be able to streamline the process, but so far I have struck out in using different combinations of VLOOKUP AND Match/Index. I'm...

I have a spreadsheet hat has multiple lines that have an identifier in column B. I'm wondering how I would go about building a macro to send the entire row while keeping the existing row to the second worksheet based off it's value. For example, send 0A on column B to 2nd worksheet as well as...

Hello, I am trying to extract the latest date from a range of dates, with a unique identifier as the criteria. My data looks like: Sheet1 <tbody> A B </tbody> <tbody> Identifier Dates 12 1/2/1900 10 3/1/1901 12 1/5/1899 13 2/3/1900 19 7/4/1901 10 4/2/1901 12 1/5/1900 14...

Hi there, This may take a while as what I am trying to acheive I believe is quite complicated. So I have a table on Sheet2 of my excel workbook, which is poulated by a userfrom, from range BO:BT. In column BO there will be a unique identifier that will appear usually more than once in the...

Hello, I would like to create a macro to help me out with some manual data processing that I do at work. I export the data into excel from a website and it is always set up with the same columns. Column A contains a 5 character identifier. (Ex. A1234). There are typically multiples rows for...

Hi folks, I am hoping for some advice on how to best perform a task in Excel, hopefully via a macro. I assume two spreadsheets in the same book. Sheet 1 Column A has a unique identifier, approximately 2,000 lines filled out from column A to T Sheet 2 has the same identifier in column A with...

Hello - I'm looking to calculate cumulative totals and percentages based on the type of data in column A (unique company code identifier) and column B (date of time entry). My time data is in column C (formatted as an integer). I would only like to calculate the cumulative total & % if the row...

I have a table that in Column A has a "Part ID" that is my main identifier. What I need is to group the $$ that are in Column D that have the same PartID. I cant figure out how to group the $$. Thank you!

I am attempting to combine data from 3 separate tabs onto one tab via a unique identifier that is on all 3 tabs. Once I have identified the unique identifier on each tab I would then like to bring over all accompanying data from each of the 3 tabs into one tab. Is this possible via a formula?

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