jones

Hi everybody, I hope someone can help with a code for this please? In the example below, I would like to split a worksheet at each change in the Location column so that the data goes into a new sheet of the same workbook, then email each new tab to the relevant email in cell E2 using Outlook...

Hi: I have a list: Ted Jones Jones,Ted In B12, I want to return "" for all values containing "," if not return cell value. So if cell value is Ted Jones, return Ted Jones. If cell value is Jones,Ted, return "" Formula below is returning cell value even if condition is met...

Hey there, i need to do what seems easy, but i cannot wrap my head around it. I have a set of data that looks like this: <tbody> HH Name Account Fee 1 Jones IRA 0.5% 1 Jones Individual 0.8% 2 Smith Joint 1.0% 2 Smith IRA 0.5% 2 Smith Trust 0.9% </tbody> I need to have...

I have a list of over 75,000 names. I am trying to get a unique count of any cell that has special characters in then except the comma (,). For the data below the count could be 7. Thanks in advance! Billard, Ny'aniah S.D. Kolman, Ja'Niyla A'Marie Johnson, Dave Holmes, Lord-Ken'th Hook-Boullai...

Hi Folks, We have a new admin system. When the data was migrated to our new system the accounts that were held in joint names names came across with commas after each person's name. Where an account was previously held in joint names but now is an account held by a sole individual there is a...

Hi there - I have a spreadsheet with a worksheet for each month containing various bits of information I am trying to set up a summary page that shows how often a term ('Smith', 'Jones', 'Johnson', etc) occurs in each month. I want to see how often a customer has contacted me each month and...

In my excel I have a person entered 3 or more times. Credit score example Bob Jones 760 Bob Jones 750 Bob Jones 740 I want to remove the duplicate Bob Jones's but keep ONLY the TOP entry which is 760 the Highest. I already have my sheet auto sorting so the top one will always be the HIGHEST...

I've created a company phone directory that is currently sorted by extensions. I'm trying to create a macro that sorted by their department. For example: <tbody> EXT. 1stNAME LastName DEPT 1234 Paul Smith Sales 4566 Meredith Jones Cook 2345 Shirley Grasse Sales 7624 Eddie Coleman Stock...

Hi all, I am hoping that the following is possible to be done with vba code. I have searched but am struggling to find code to cover all of this. I have broken this down into 3 separate stages below. I have a set of data in an excel spreadsheet that runs from column A to Column K and 6000...

Hello, I have single column in Excel with 6 unique values and I want to list all possible unique combinations (combinations of 2, 3, 4, and 5). Example: Column A John Jones Jamy Sarah Mark Mike The output I'm chasing is all possible combinations of 2, 3, 4, and 5. Example: (John, Jones)...

Hi, I have in column D a list of employees names and last names: Mark Jones Tom Smith Robert Brown Lewis I need to split the names and last names and create two columns: <tbody> Names Last names Mark Jones Tom Smith Robert Brown Lewis </tbody> Can someone please help me...

can anyone help with a formula to calculate rank based on dates? I have 3 fields, Column A Salesman, Column B Customer, and Column C DateSold. I want to rank each sold date (oldest to newest), by Salesman. So Salesman Joe Smith's 1st sale was the oldest datesold, and his 2nd is the next...

I would like to rank a matrix by value (with corresponding name) per time period. Also, as the matrix will be a bit larger, I would like to indicate every person with a different color. That way one can easily see how each and everyone performed over time. So in the result, the background of...

Hi, we have to collate reports from different departments. And I've been asked if we can help sort out (an evergrowing!) snag. There is a list of info <tbody> Customer Name Orders PETER SMITH ABC123 david jones 5962-99-3 peter smith XYZ789 222246 Green Bottles David Jones David...

How can I get just the initial of the name (ie in example below I want just L, C, R etc) Smith L Jones C Goodman R

hello all, this one is pretty self-explanatory. I have a button I want to press and search range S14:S40 and if there is any text in there add something to the end like A or Jones. that will enable me to redirect my spreadsheet to do an alternate calculation which I should have under control.

<tbody> 1 A B C D E F G H I J 2 2017 2018 2018 2018 2018 Year 2018 3 Employee Dec Jan Feb Mar Apr Month Feb 4 Doe John 20.00 22.00 23.00 24.00 24.00 Employee Jones Mike 5 Jones Mike 15.00 17.00 18.00 19.00 19.00 Rate ??? </tbody> I have the above table (B2:G5)...

Hi, I have a workbook with thousands of unique names in column 'J'. The other columns also contain these same names, often repeated many times over, with a different number value alongside each name. The numbers are one space to the left of the names. For instance John Jones may have a value...

Hi All, I have data that has multiple names all in one cell, which looks like this: A John Smith B Dave Smith C Jack Jones D Eric Jones Is there anyway I can split the names into individual cells? It is ok if the letter comes with the name like so: A John Smith B Dave Smith C Jack Jones D...

Hi everyone, its been ages since ive been able to post, but it feels good to be back. I hope everyone is well. So, I have a small request that for some reason I just cant seem to figure out. I need to have excel do a lookup and countif, or some version of those. I have pasted a view of what I...