I have three columns of names. I need to loop through the first two checking to see if any name is in the third column and if so, place a 'found' in a fourth column.
I created a validation list that includes the names "Mary, Joe, Michael, and David"
When I plug in the name "Mary" I want to pick out her qualifications from a list I have created on a separate worksheet.
Passport Mary Joe David
Lunch Mary Joe Michael
Car Joe Michael David
I want Excel to have the ability to find the name "Mary" from those three lists and reply back to me with the headers of either Lunch, Car, and/or Passport based on the lists Mary appears in. I want this to change depending on the Employee Name and I pick and the lists they appear in.
I have two columns that is use to record last name first name. I need a macro that will find matching names in the columns. i have found some examples for searching one column but have not had any luck finding someway to do 2 columns. in the example below i need it to find and highlight The names Smith John.
I have a large table of data which I have used the "create name from selection" tool to name according to the top row and left column.
On a separate sheet I want to have another table where the user can choose which data to see.
I have a drop down list which is named and then a column of dates. In the column next to it I want to show the data which is in the cell which corresponds to the selection in the drop down list and the date next to it (named as the top row in the original table).
I have tried to use INDIRECT and VLOOKUP but I can't figure out how to get the contents of a cell to show up.
I have two different lists of names. One is about 3000 names long and the other has about 3500 names. I want to identify the 500 people that are not in the first list that are in the second. If there anyway to do this? I was going to put them in A-Z order and then go through and using an IF(A=B,"yes","no") and go through and insert new cell when ever it says no till it says yes BUT the functions start messing up when I insert a new row and it's taking way too long.
In column A I have a list of 5 Auditors labelled Q1 - Q5, 5 Coolum’s across in column F I enter in their scores as a % e.g. 80%. ...So Q1 - 50%, Q2 - 60%. In column A37-A41 I have Q1-Q5 listed, in Column B37-B41 I need to calculate the average deviation per Auditor eg. If Q1 has 2 entries of 50% and 75% return average value in cell A37 which should be 62.50%. I am trying to calculate the average for each Auditor. find attached example.
Magazine subscription list. How to highlight the customers that are already in the sheet if enter them again (renewal). Our list is like so....
ColA ColB ColC ColD ColE ColF First Last 123 Ave City State Zip
Is there a way to highlight the row if the info on ColA, ColB, ColE, and ColF all match? Sometimes the Street info is abbreviated or entered PO Box instread of P.O. Box and they wind up on the list a second time.
Looking for a formula (not macro) that can do the following:
I have a spreadsheet and in one column, it has last names of clients. In the next column, it has full names of clients that are the same account, but different system with different descriptions for the name. I need to lookup the column that just has last name and see if that last name exist anywhere in the "Full name" column. If it does, then I need column C to say "Yes" or something along those lines.
The "full name" column isn't always in the same format and sometimes doesn't even contain the "last name." Sometimes the last name will be first and sometimes there's a comma and sometimes there isn't a comma. The spreadsheet attached shows a good short example of what I'm working with...
I need to look up the name in E2 in the list in column A and if it matches then lookup name in F2 in list column b, if it matches then the corresponding number in column C is displayed in column G. If neither names are in the 2 columns the words"Not on lists" is displayed in cell in column G.
The other problem is one name is spelled two different ways I want it to look for both spelling before moving on to looking up the second name.
I started with this formula but I'm getting #N/A or "not on list" when they are on the list. I'm using ranges prod_sum is columns AthruC, Last_name is range BthruC. =IF(AND(VLOOKUP(F4,prod_sum,3,0),VLOOKUP(I4,last_name,2,0)),"not on list")
I have a spreadsheet with two columns - one with names, the other with values. In some cases, the values column alongside a name is blank. Is there a formula-driven method (not a pivot table) that could produce a separate list of only the names that have a value in the value column? The formula needs to be dynamic, not produced via a filter.
The following code works to update the target sheet based on matching column names within the source sheet.
However, I would like to bolster this by not only updating based on matching field names, but also the primary key in column A. Meaning the data from the source sheet isn't always in the same order (based on primary keys) as the data in the target sheet. So I want to keep the order of the primary key in the first column and then update matching field names in column B through the last column where the primary keys match between the source and target worksheets.
Sub CopyDataBlocks() 'VARIABLE NAME 'DEFINITION Dim SourceSheet As Worksheet 'The data to be copied is here
I have two columns. One column has UPCs - some of which are duplicates. The second column just has number values. I'm trying to add the sum of all of the numbers in column two which are attached to their respective UPC. For example,
COL A///// Col B 11111111111///// 10 00000000000///// 15 11111111111///// 10 11111111111///// 4 00000000000///// 2
So, I need a third and fourth column to give me the total value for a single SKU(col A) of all the values in col B. In this example the Third column would contain the SKU, and the fourth column would contain the sum of all values in column B that are associated with the single SKU in column three. The third and fourth column would look like this:
COL C///// COL D 11111111111///// 24 00000000000///// 17
I have copied column A from a PDF file. It contains entries like this, all in the same column:
5 0.002HP Direct- 26845 7/1959 Airesearch
This column contains an ID # (5), a description (0.002HP Direct), a part # (26845), a date (7/1959), and a manufacturer (Airesearch). All this info is in one column. This column is 11,000+ entries long.
I have column B which is 45,000+ entries long, and contains ONLY part numbers, like this:
325111
I would like to compare column B to find the matching results from within the text of column A, and put these matches into column C.
augmenting current code to select the column after a column. Current code is:
Code: If Sheets(data_sheet1).Cells(2, iCol).Value = "Stations" Then TargetCol = 1 If Sheets(data_sheet1).Cells(2, iCol).Value = "Agency" Then TargetCol = 2 If Sheets(data_sheet1).Cells(2, iCol).Value = "Advertisers" Then TargetCol = 3 If Sheets(data_sheet1).Cells(2, iCol).Value = "Product Code" Then TargetCol = 4 The next line should find the column after "Product Code".
I have a working formula that gives me the last value in a column using Index formula below. How can i slightly adapt the formula to find the maximum value in that column instead?
Using and array to go through a series of sheets and do stuff (Thanks Gerald and Von Pookie BTW). I have used code which finds the last row (varies from sheet to sheet), but not the last column (which also varies sheet to sheet).
Finding Last row LastRow = Range("A" & Rows.Count).End(xlUp).Row
However this code doesn't seem to work for last column...sample... LastCol = Range("A" & Columns.Count).End(xlLeft).Column
Is there a trick I'm not seeing? Does this only work using the 'Cell' function in VBA? If so, how would the line of code look? I'd really prefer finding the column letter as opposed to using the 'Cell' method if possible.
Can anyone give me the version of this that would find the last cell in a row that contains data. The code would be used in a loop so I would need the row reference to be a variable.
I need to append this macro to find the next empty column to place the data in. The orignal VBA works fine, but I need to go into the editor, and repalce the offset number every time I add a new row (weekly).
I have a large list of numbers in two columns. I need to know what numbers are in column A but don't appear in column B. For example if the numbers are 1 2 and 3 in column A but column B only has 1 and 2 I need to know that 3 is missing.
the only thing I can think of is doing =IF(A1=B1,"TRUE","FALSE") however typing this a thousand times would not be practical.
Is there a macro that can check column A against column B and tell me which ones are missing?
I have a 70x70 table where I teased out the largest 20 values. I'd like to utilize a formula to deliver the column headings (as well as the row) headings for each of these 20 values. VLookup and HLookup don't seem to work for me, and Index/Match seems to only work for single columns.
It might be worth mentioning that is highly unlikely that any of the values in the table are repeated.
I have one column that has over 120,000 rows. In the column it is split into sections. I can manually find the min max from each section but would like to know how I could do this automatically throughout the whole column.
Why is lastRow always returning 1? Even after adding values to worksheet and running macro - its always returning 1 for lastRow.... Am i missing something here? Do I need to refresh worksheet or something? I just dont get it :/
.Range("B:B").End(xlUp).Row
Code: Option Explicit Private lastRow As Long Private curRow As Long[code].....