jon

  1. A

    look for a tect anywhere on the cell

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

    Pivot Table: count multiple columns

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

    Excel VBA Sort on using two columns

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

    formula to remove a space and replace but depending on the details

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

    Adding More Conditions to an Existing Formula

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

    Random Sampling Based on Weighted Criteria

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

    If - and - vlookup

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

    Vba datepart question

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

    Solve the Problem of the day?

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

    Reverse Concatenation

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

    Preventing a duplicate rows

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

    open excel with macro via outlook and pass on a parameter to the macro

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top