smith

I have a list of positions for employees that are in one cell that I needs to be in rows for each employee. Text to column doesn't work and neither does any sort of text formula like =left, =mid, etc. I have over 2500 employees and th <tbody> Active Status Emp ID Worker Hire Date Position ID...

In column A I have a list of names. Example: Column A: In Attendance Smith, Joe (Joined in Skype for Business) In Attendance Doe, John (Joined in Skype for Business) In Attendance Smith, Jane (Joined in Skype for Business) I want to search column A to see if certain individuals show up. For...

<tbody> A B A Anderson Alex Anderson B Smith Brandon Smith </tbody> - I pasted my list of names in sheet 1. - I need to FiIND A1 (entire workbook) and replace all instances with B1. - then same thing for A2 to B2 and so on so forth. Thanks in advance

I would like a Macro to add 001 after a name. This will now be a one off press of a button then not used. Some info for you. Worksheet called POSTAGE Column B Range B8:B881 I now need to add "SPACE 001" no quotes to All the names which do not have 002 003 004 etc after them. My list at present...

I'm trying to make a directory in Excel. Say I have a sheet that lists all of the members of an organization such as this: Member # Name Date Joined 27 Smith, Bob 04/05/1998 42 Jones, Larry 06/07/2000 143 Wilson, Frank...

Hi, Can I have some help. I want to create a list of unique names based on their lowest score e.g. Surname forename Score score Smith Dave French 3 Smith Dave French 1 Holland Fred Science 2 Holland Fred...

I have three columns, 1st column has Sales peoples names in it, second column has type of order and third column has the total of the order I would like to look up all the orders for John Smith, that have been won and total the value of the orders. I was using sumifs and its not working, is...

Hello, I currently have this code: Dim FileName As String FileName = Sheets("Tracker").Range("A4") Dim FileName1 As String FileName1 = Sheets("Tracker").Range("A5") Set wB2 = Workbooks.Open("file location") If wB2.ReadOnly Then ActiveWorkbook.Close...

Hi, is it possible to get a pivot table to display a text value (persons name) multiple times? For example, I enter a persons name, 'John Smith', and a number '225588'. If John smith or another John smith information is entered again the pivot table automatically combines the name as one, John...

Hello and thanks in advance for the help. Below is a string of characters and I need to extract the last name of the employee. The format will always be the same, there will always be 3 numbers to the left with a space between. I can extract everything to the left but my limited knowledge...

Trying to put together a formula to tell me the number of hours based on the following parameters: 1. Time between Online/Offline 2. Online always is first 3. How much time between Online and Offline for the day 4. Some times multiple entries for a person within a day 5. Sometimes Online will...

<tbody> ID FIRST NAME LAST NAME DATE PHONE# 1 ALLAN SMITH 05/30/2019 4701325555 </tbody> To become like this: <tbody> ID 1 FIRST NAME ALLAN LAST NAME SMITH DATE 05/30/2019 PHONE# 4701325555 </tbody> Hi, 1. I have an excel file with over than 200 columns, I...

I have a spreadsheet that contains multiple rows of data for multiple dates and companies. I am looking for a way to show all of the entries for the specified company within a specified date range. For example, I want to see all of the entries for company ABC between 1/1/2019 and 1/5/2019. I...

Hi was wondering can i setup a spread sheet to delete a column of data if one of them coloums is missing say a certain name ie "fred Smith" and also can it delete whole sheets from the workbook when a certain date is reached all without the use of a macro. Regards Mark

Hi. I have a Userform that some users complete to update info on a (large) table. I've added a bit of VBA to get the date added when the user who has opened the spreadsheet makes a change to the database but I'd like to be able to add their name too. However, when I use Application.Username I...

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

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

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! I need to clean up a excel file (2016) with approximatley 2000 records where many of the names and addresses are all caps or all lower case. Is there a forumula I can use to identify these records and change to proper case formating (JOE SMITH, 123 main ave. change to Joe Smith, 123 Main...