smith

I have been given a list like so; stan smith joe wilson ken hanson mike jablonski I would to have the list look like so: stan smith | joe wilson | ken hanson | mike jablonski the substitute value only works with a specific set value. so it would set the first delimited between smith and joe...

Hello all, I have a list with names of individuals and repeat addresses. I would like to find a way Duplicates. Thanks in advance. <tbody> 1 A B C 2 John Smith 2 Main St Apt 5B Duplicate 3 John Smith 2 Main St Apt 5B Duplicate 4 Jason Bourne 5 Rock Road Apt 2B Not Duplicate 5 Jason...

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

<colgroup><col><col><col><col span="17"></colgroup><tbody> I need some help I have a training spread sheet. On the left i have a list of names. The the right of the names i have a series of columns...

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 have a client name in 3 or 4 rows. Each row has a different service with different units and unit price. I want to have each client have one row, and the service hours and price in different columns. Example Smith 3 units $5.00 per unit Smith 4 units $3.23 per unit I want Smith 3 $5.00...

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

Good day, I am trying to add Mr & Mrs to a formula. I have a long list of names, both single (Mr J Smith) and married couples (Mr AB & Mrs CDE Smith) Currently the formula looks like this: =IFERROR("Dear "&LEFT(A5,FIND(" ",A5,1)-1)&" "&RIGHT(A5,LEN(A5)-FIND("*",SUBSTITUTE(A5,"...

Hi , I am trying to create a formula column which shows how many days members of staff have worked in a row. A B C Name Date Number of days in a row J Bloggs...

Looking for a way to copy data from specific rows to specific sheets. Example: Look at Column K for name, and copy the data for that row in to it's own (already created) tab. If the name "Smith" is in column, that row goes to the Smith tab, etc. My data set is in the "Working Copy" sheet...

Hi, I have an excel sheet that has over 34,000 rows. It has the employees name, payroll date, and time card hours. Example: Payroll Name File Number Payroll Pay Date Timecard Hours John Smith 0012345 07/26/2018 8.00 John Smith 0012345 07/27/2018 8.00 John Smith...

Hi, I have an excel sheet that has over 34,000 rows. It has the employees name, payroll date, and time card hours. Example: <tbody> Company Code Payroll Name File Number Payroll Pay Date Timecard Hours PayCode AAA John Smith 0012345 07/26/2018 8.00 Reg AAA John Smith 0012345 07/27/2018...

Hey all, FormR kindly helped with combining two formulas together: =IF(AND(INDEX(T:T,MATCH(E5,AF:$AF,0))=G5,INDEX(BJ:BJ,MATCH(E5,AF:$AF,0))=H5),"Yes","No") This formula is replicated in Rows until 1500 i.e...

Hi I need a code that will copy and paste data from column D to column B if column B is empty, the code will ignore any empty cells in column D and move to the next cell with data to copy over. From this <tbody> A B C D JANE JANE DOE JOHN DOE JOHN DOE JANE JANE SMITH JOHN SMITH JOHN...

I have a worksheet that contains last names in cells A1:D10 (all unique). I have named a range (Qs) in the same workbook and that range contains 3 names in cells a1:a3 - Jones Smith Riley Is there a conditional formatting formula that will format any of the cells in A1:D10 where the last...

I have a workbook that has employee info in sheet1. Sheet2 lists the employees dependents with corresponding employees social security number in column A. Some employees have multiple dependents listed in multiple rows. Is there a formula that I can use in sheet1 to list each dependent in...

Hi I have a spreadsheet im trying to complete which if done manually will take forever but i cant work out how to automate. In one sheet i have information as per the below Date Employee Name Holiday taken 02/06/2018 Joe bloggs 03/06/2018 Joe bloggs 06/06/2018...

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

Hi all, I am struggling with this for a while... I have the following excel sheet as an example data set Column A Column B Column C Column D 1 First names Last names Fruits...

Hi there I have some data that I want to pull out the 'max' and by 'who' within a defined month. I've managed the max formula ok but struggling to build the month part into my index/match array. Any help would be truly appreciated...