jane

I have a date range with names in column A and column G will count how many times this person is signed up for a class between column B to column F. Taking into account how many classes the person is taking, I need to return their names in a list that many times Data Range <tbody> A B C D...

I don't know if I need to use VLOOKUP, INDEX, MATCH or a combination of them. I need to get the employees review dates from Sheet 2 into Sheet 1. The dates on Sheet 2 are in a row, and I need them on Sheet 2 in a column, but I need them in the correct month. So using Sheet 1 A3 as an example...

Hello. I have a bit of an issue. I am trying to combine a first name and last name with a comma in between. For example, I need Jane Doe to become Doe, Jane. Cell C1 is Jane Cell D1 is Doe I have used these formulas: =D1&","&C1 =CONCATENATE(D1,",",C1) In both cases the result is: Doe...

Hi All, I hope you're enjoying the weekend. I wonder if anyone can help with the following formula. I'm trying to pull a date from another table but only if it matches certain criteria. Table with Data <tbody> Unique Identifier First Name Last Name Course Date Grade 12345 Jane Doe Course...

Hi, <o:p></o:p> <o:p> </o:p> Wondering if someone could assist me with some code to identify cell differences in a spreadsheet.<o:p></o:p> <o:p> </o:p> I need the macro to highlight the cells that have the samefirst name in column A and different values in the direct cell below in column...

Hi all, I've been breaking my head on creating a formula that calculates values in column Z. I have a reference table that contains data ranges as shown in column C in the reference table. I also have a database where I would like a formula to show me the category number from column B (1,2 or...

Greetings, I have 2 spreadsheets that I am working with who's data I am trying to merge so that each person will end up with only one row of data. One spreadsheet has the orientation completion date in it, while the other has the checkin date. I copied and pasted worksheet 2 into the bottom...

Hi, Need additional brain power on this one. I'm trying to use conditional formatting formulas to find the Sales Name AND match to the Sales Acct. IF the name cannot be found the row highlights red. If the Name is found but the account cannot the row highlights red. I've tried his formula...

Hello All, here is my excel problem. Smith, John Doe, Jane Smithss, Jack Whitess, John Blackss, Jane Bluesss, Peter Longlastname, Phillip I dont know if it's possible to have these converted to usernames. The format is 6/1 (first 6 character of last name and 1st character of first name) of...

Hi, I have been working on this for more than 4 hours and reviewed so many formulas online. I need to create a mail merger with multiple rows. Here is the sample data, I have more than 700 individual employees on the sheet. I need to show on one page per employee all the applicable Bonus plan...

I have a large spreadsheet with duplicate entries adjacent on 2 rows is there a formula for this they are marriages and need pairing up as you can see from the reference numbers on right side are the same that I have edited. They are in pairs with the same reference...

Hello I'm having trouble with a spreadsheet I have created. When I turn on the filter I can't get the information to display as I want. Please see example layout below. <tbody> A B Committee 1 Joe Smith Jane Brown Committee 2 Alex Davies Heather Nimmo Committee 3 Tom Munro Jake...

Hello, I currently have a table with a couple thousand pieces of data. What I am trying to do is create a formula of some type to know all the corresponding dates to a certain person based on their status. <colgroup><col><col><col></colgroup><tbody> Name Status Last Modified John Doe...

Most of customer list comes in as: Doe, John or Doe, John & Jane It easy to change those to: John Doe or John & Jane Doe by using: =TRIM(MID(A2&" "&A2,FIND(",",A2)+1,LEN(A2))) However, we also have customers entered as: Doe, John & Smith, Jane and we'd like to have it appear as...

Hi, I'm trying to automate a really long task I have to preform daily at work with VBA and although I'm almost a complete noob with VBA, I have managed to get majority of it done except for this one last step, so any help would be greatly appreciated. Basically I have a worksheet with 4...

I'm trying to manipulate a very large file into a new format so I can work with it in Visio. For context, it's a succession planning file, where each current incumbent has their own row, but with each successor they add a row. For example: <tbody> Current Incumbent Successor Jane Doe Bob...