jones

I have a table of courses with the name of the student. Then I have another table that I am trying to get a Yes or No value based on if they took the class. I believe I need a vlookup function, but I am missing how to get that data. Student Course Tom Smith Math 101 Jerry...

Hi, I have a worksheet called POSTAGE. There are customers names in column B Current range at present is B10:B979 I would like some help with a basic code where any customer that doesnt have a number after there name then the code would add 001 So TOM JONES would then become TOM JONES 001...

Morning, I am using the code supplied below. When i open my worksheet i start to type a customers name in cell A6 When i leave the cell the code checks to see if this customer has purchased from me before by looking down column A & if so it then shows me the msgbox "A Duplicated Customers Name...

Hi On Sheet1, I have the following columns of data <tbody> A B C D 1 DATE NUMBER NAME TYPE(S) 2 01/01/2019 123 J Bloggs A,B 3 01/01/2019 456 D Smith A 4 01/01/2019 789 P Jones B,C 5 02/01/2019 123 J Bloggs B 6 02/01/2019 789 P Jones D 7 03/01/2019 456 D Smith A,B,C 8...

Hi All I have been struggling with this one. I can do it if its a duplicate but not with different criteria. Basically I need to get a formula, preferably using conditional format ( so it colours the rows) I want it highlighting if as example Mr Jones had bread, doughnuts, and cake in the same...

I want to extract text before a comma, or space or if condition 1 or 2 is not met return text in cell: Example: James, John Jones Tom Lily Expected result: James Jones Lily =LEFT(A1,(FIND(" ",A1,1)-1)) extracts text before space =LEFT(A1,(FIND(", ",A1,1)-1)) extracts text before comma...

Hi, I have a column with address details. I would like to separate the house number (always on the left) from the string. In some case, there might not be a house number, while in some other cases there might be a house and a flat number. I am only looking for the house number. Table below...

I'm trying to get data from multiple TXT files into Excel. Each TXT file represents 1 row of data on the excel workbook. Each section of text the TXT file represents the corresponding column in that row. For example: Everything after "Other Observed Names" would go in a column labeled "Other...

Hi, I am trying to extract text from a cell to reformat and remove some parts. Jones, John (London) would want to be changed to John Jones I have tried using the LEFT/RIGHT/MID and SEARCH formulas but i have not been able to tweak it to correctly show what i want. Can you please help

<tbody> A B C D E F G H 1 PITCHERS WIN LOSS DATE WIN LOSS PITCHER 2 DAVIS 3/30 1 DAVIS 3 SMITH 3/31 1 SMITH 4 JONES 4/1 1 JONES 5 WILLIAMS 4/2 1 WILLIAMS 6 4/3 1 DAVIS 7 4/4 1 SMITH 8 4/5 1 JONES 9 4/6 1 WILLIAMS 10 4/7 1 DAVIS 11 4/8 1...

I'm stuck on what I think is a simple issue and can’t seem to figure out what is needed – any help is appreciated! I am looking to take a vertical list of data and pivot only two columns into stretching across the row, while keeping only one line for each unique Customer ID. My list has about...

Afternoon. In a worksheet at column B is a list of customers names. When a customer makes a return purchase their name is then followed by a number. Example, Tom Jones Tom Jones 1 Tom Jones 2 Tom Jones 3 At first it was fine but now introducing a combobox list once the numbers are greater...

Have: Jones, Mary / Jones, Sam (or could be three names) Jones, Mary / Jones, Sam / Jones, Tom Need: Mary Jones; Sam Jones (or all three names if case may be)

I have a full name in a cell and want to convert it to last name first initial only in another column Have: Smith, Mary Want: Smith, M some cells have: Smith, Mary / Jones, Sam Want: Smith, M; Jones, S

Can I do this. I want to select only Smith. I want patients who do not have a billing code of Z00.00 or Z00.129. the data is across 6 sheets. I want to export only Smith. Name Pat# Bill code Jones 123 F34 Jones 123 H01 Jones 123 Z00.00 Jones 123 090 Name Pat#...

<tbody> Name Number Amount Total Brad Jones 1234567 35 Brad Jones 1234567 19 Brad Jones 1234567 10 Joe Bob 9999999 55 Steve Smith 1111111 60 Steve Smith 1111111 40 </tbody> Hi, I am looking for help to make a formula or macro for this spreadsheet. I am not great at excel...

Hi all, I am trying to conduct a matching of data between a database of contacts and separate database of enrolments to see whom from the data base has enrolled so far. As representative example of the two sets of data: My data set: <tbody> A B C D E F G 1 First Name Last Name Job title...

Column A of sheet 1 is populated with names.....via list validation Column U of sheet 1 has a $ amount Lets say in A2, i select the name Bob Jones.....fill out some other stuff and the total cost in U2 is $400 On sheet 3, B2, I have this formula...trying to capture the total number of dollars...

Guys, not even sure if this is possible. I have an excel table called 'Newport' which consists of the following 9 columns: Dealer, DecsR Attempt - (this column will only consist of New, 1st, 2nd and 3rd) RegNO, Salute, Updated, Contdate, Completecode The table normally has around 2000...

I have a list of employees in a spreadsheet where I record if they paid their dues or not. I am looking for a formula solution to generate a list of employees that have paid. I understand this can easily be achieved by filtering, but in this particular case, I want to use a formula. <tbody>...