john

Thanks for taking the time to read. I have a list of surnames in Column A and first names in column B and I need to combine the two into one cell which I can easily do by joining strings. However I also need the format changed with characters adding so: from this: Smith John to his: Smith...

Hi. Ive tried a couple of formulas to do the below, but don't seem to be able to get one to work. Hoping somebody can help me. Essentially, I have a column with names (lets say column A) and in column B numbers. The column with names will have multiple occurances of the same name but may have...

Column A has an Employee Name Column B has a Date An employee name can repeat on the same date I want to know by month the sum of the count of the number of unique names each day. John Doe 4/2/2019 John Doe 4/2/2019 Jack Smith 4/2/2019 John Doe 5/1/2019 Jack Smith 5/19/2019 Jack Smith...

My data set has a list of people with an assignment date. Each person can have multiple assignment dates. I need to find the earliest assignment date for each person. I am trying to solve this by first doing an index match array formula to identify all the assignment dates and then applying a...

Hello, A similar question was asked a few years ago, but in this case, I have a data sheet of names that look like this: Smith, John Q and I just want to remove the middle initial at the end, like: Smith, John Seems pretty simple, which is why I haven't quite figured it out yet...

Hi all, I've created a User Form that loads up upon opening up my spreadsheet. My goal is to take that user input and have it be placed in cells appropriately. Here's my form fields: First/Last Name Account Number Payment Amount Due Date # of Coupons The user inputs data into this form...

Hi smarties I am trying to make a table that turns this: <tbody> John potato 1 Mary cranberry 5 David salsa 4 Stacy potato 6 Greg potato 2 Anna salsa 3 </tbody> Into this: <tbody> John Potato 1 Mary Cranberry 5 David Salsa 4 Stacy Potato 6...

I have a question on returning X customer's discount percentage Y, based on their Z spend amount.Ie: I have a list of 5000 customers, Various min and max spend and its corresponding discount. For customer John, i can locate John by index match among the list of customers. Then when at customer...

<tbody> Column A Column B John John Search value entered to be used in VBA Mary Mat Johnny MaryS </tbody> I want VBA to find information in the worksheet, where the VBA find function uses the supplied search base from the excel sheet.eg above. The VBA code must find...

I'm looking to find a way whether it be in excel, power query, power BI or Pivot to display the top 20% of customer sales per agent without the need to create a Top 20% Conditional Format for each agent and for each update. Agent/Cust is a concatenation of the agent name and customer number...

I have `ThisWorkbook.Sheets("MAIN")` and ActiveX `ComboBox11` on it. I also have table: A B 1 John 1 10000 2 John 2 20000 3 John 3 20000 4 John 4 10000 5 John...

I have a sheet that is similar to the following: <colgroup><col span="2"><col><col></colgroup><tbody> A B C 1 Name Item Description 2 Tom Smith 1 Item 1 3 John Adams 2 Item 2 4 John Adams 3 Item 3 5 Ronald Regan 4 Item 4 6 Ronald Regan 5 Item 5 7 Ronald Regan 6 Item 6 8 John...

Hello, I have cells that contain text and people's full names. An example of the verbiage in cell A1 is: "Total For Smith, John C" I'd like to just have "John" display in B1. There are also some names that do not have a middle initial. Thank you so much!

Hi There, I'm analyzing a large amount of time entry data (30,000+ rows). I'm trying to calculate the day a project started and ended for one person...in the example below I'm trying to solve for when the project started and ended for Amy (via a function). <tbody> Project # Name of Person...

Hello I would like to pull in the fields "Name" and "Comments" from one worksheet into another based on the criteria "where Active = X"). So John Smith and his comments would get pulled into the new worksheet. Thank you <tbody> Name Comments Active John Smith lorem ipsum X Sam Smith...

I want to Sum values from Column A based on a specific Value in Column B. In the sample below I would want the total for each name based on values in Column A. For Example, John would = 15 total, Ryan = 7, etc. <tbody> # 12 John 5 Ryan 7 Mike 3 John 2 Ryan 5 Mike...

Hi there! This is my second time playing with excel, so please bear with me. I have a string of data in column A (lets say the data name is John,James,Jerry,Jay and Jim) and with each data holding values. My intend is that the formula will compare the names with a cell (lets say G10 which...

Hi All, I am trying to create a spreadsheet for a cycling l club I am in. I am trying to build a text string of numbers based on results achieved. The first one I am trying to do is look up a persons name and their results at a certain location. So for John Smith from the results below I...

Hi All, I am having a real problem with return the time of a cell using 2 criterias: This is the data table: A B C D 1 02/01/19 John 08:16 06:40 2 03/01/19 Bob 08:20 05:30 3 04/05/19 John...

Hi I have a long series of data that contains names in column A, Products in column B and quantities in column C eg: <table> <tr> <th>A</th> <th>B</th> <th>C</th> </tr> <tr> <td>John</td> <td>Apples</td> <td>7</td> </tr> <tr> <td>Steve</td> <td>Apples</td> <td>4</td> </tr>...