jon

i need to use the if statement to see if the word "John" is a cell in a column. How do i word the IF statement. Jon can be anywhere on the text on the cell thanks all

I've got a worksheet in which each row represents a specific task. For each task, there will be at least one assignee and perhaps up to four assignees. I'd like to make a pivot table that will count the number of times each assignee has been assigned to a task. Currently, when I add each...

Hello, I need assistance adjusting a macro. I need to sort one value alphabetically, then another value chronologically. For example, I need Jon Smith 10/9/2018 Jane Smith 10/31/2018 Jon Smith 9/30/2018 to become Jane Smith 10/31/2018 Jon Smith 9/30/2018 Jon Smith 10/9/2018 I cant figure...

Hi Everyone, Ok so please help with this formula if you can? I have names in column B I need to change the way they are recorded for our new system. In colunm "B" I have names that are all set up as either sir name and first name or sirname and initial. I need to reove the space between...

I have a formula that currently works correctly that is located in cell L2: =IFERROR(VLOOKUP(B2,'Site Assignments'!$A$1:$D$131,4,FALSE),"ASK JON FOR INFO") Now I want to add logic that says if cells F2 and I2 are blank, then leave L2 blank I think what I need to add to the formula above is the...

Hello, I'm trying to find a formula (Or VBA, but i have close to zero experience on that) that retrieves me a series of random samples based on a weighted criteria. Let's say i have the following Table <tbody> Jon 1 Mike 2 Jon 3 Jon 4 Jon 5 Mike 6 Mike 7 Zero 8 Zero 9 Jon...

Hi Everyone, I have a table where I'm trying to lookup a transaction ID for a particular sales member. I'm not sure how to approach this and my efforts around an IF( AND( VLOOKUP( formula have proved futile. The following tables show what I'm trying to accomplish. TABLE 1 <tbody>...

Hi, I have a query regarding DartPart and the format of the value it returns. My example is using date 01/01/2018 If I use DatePart("d", #01/01/2018#) the value is returned is 1. However, what I would like is to have the value, if less than ten, to have a proceeding zero, eg 01. How would I...

I am using Index/Match to utilize a lookup of phone numbers. HOWEVER - - - If there is a misspelling or an addition of Jr, Sr... etc.... It clearly does not work. I am looking to use a wildcard function in my search but running into road blocks. A = Names B= Phone Numbers Look up = C1...

The question is of reverse concatenation in Excel VBA. I currently have this: <tbody> Joe, Jon Joe, Pam, Carl Joe, Jon, Jeremy </tbody> And need to reverse concatenate so I can then have each individual name in its own row and cell as follows: <tbody> Joe Jon Joe Pam Carl...

I have a report where I'm listing locations and President-Co-President. I have at 41 different entries and several of our sites have multiple people in one position (a president and co - president). I would like the report to skip the local for the second person listed. In other words, if I...

Hi All, I created a userform on excel to manage and track deliverable/tasks. Currently, tool assigns the task to a certain e-mail distribution but we wanted to take one step further and assign the tasks to an individual (after it gets assigned to the group). Easy enough, I can create a form...