smith

My Data <colgroup><col><col><col><col><col></colgroup><tbody> 1 A B C D 2 Sequence Date/Time Who What 3 1 10/1/18 2:41 PM John Smith Open* 4 1 10/1/18 2:41 PM John Smith Edited 5 2 10/4/18 2:15 PM John Smith Open* 6 2 10/4/18 2:15 PM John Smith Edited 7 3 10/5/18 2:16 PM John...

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, I am a bit stuck and was wondering if anyone has any ideas. I have an extract from Exchange that has data similar to this..lots of rows but need a formula that searches each row for "*newmail.com" and appears in the NEWMAIL column (C): <colgroup><col width="75" style="width: 56pt...

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 spreadsheet with 1000 rows that look like this: LNAME FNAME YEAR DONATION Adams John 1995 100 Adams John 1996 150 Smith Bob 1995 100 Smith Bob 1997 175 Smith Bob 1998 150 I want to transform the spreadsheet to this, with only one line per donor: LNAME FNAME YEAR DONATION YEAR DONATION...

I have a number of cells and I am looking to remove the duplicate strings (2 characters or more) in them. Is this possible with an existing Excel formula(s)? It's ok if I need to use helper columns (C, D, E...) For example: A1 = Jane & Bob Smith Smith A2 = Joe Johnson Johnson A3 = Sally and...

On Issues w-out action plans, the name won't match exactly with F4, it has an initial for example John Smith or John Smith T. I want it count if it finds the name similar under columns P:P, how would I write that into this code below please? =IFERROR(COUNTIF('Issues w-out Action...

If you have a table of data, say: <tbody> Name Age Gender John Smith 45 Male Jane Smith 44 Female </tbody> To which you apply an advanced filter which returns cells with ‘Male’ in the Gender field, is it then possible to assign a name to that filter i.e. return a separate column which...

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

Hello. I have a column of cells that contain a first and last name. Is there a way I can trim that cell from the full name to an abbreviated name as follows: cell B2 shows "Ann Smith" - this is provided for me. I want cell C2 to show "ASmith" Do I need to break Ann Smith into 2 columns, then...

<colgroup><col width="64" style="width: 48pt;" span="9"> <tbody> I have 2 data tables with colours in row 1. The same colours can be in both data tables (not necessarily in the same columns). In A2-A100 I have names. I need to sum all the colour red sales made by Smith...

I have a list of first and last names names which run into each other in one text string e.g. JohnSmith, DavidJones etc., is there a formula to separate these out into two columns - John Smith, David Jones?

Hi I need some help here - basically i want to lookup a list of bank transactions (sheet 2 column f on a row by row) and return the word "NEVER" in column G next to the transaction if it can match part of a word as found in Sheet 1 column A I need to find the unique words on sheet 1 (eg. smith...

I am trying to look at my employee time sheets broken down by date, time, and who was on at the time. My time sheet software give me their clock in and clock out time. I've used MROUND to get the closest hour, now I'm struggling to put those names in the correct time slots. This is the data I've...

I found this code on the forums posted by MickG: Sub MG02Sep59 Dim Rng As Range, Dn As Range, n As Long, nRng As Range Set Rng = Range(Range("A2"), Range("A" & Rows.Count).End(xlUp)) With CreateObject("scripting.dictionary") .CompareMode = vbTextCompare For Each Dn In Rng If Not...

<tbody> Hi I am trying to update my updatesheet data to mastersheet via headers with vba. Anyone can help me Master Sheet A B C D 1 First Name Last Name Age Salary ($) 2 John Smith 50 5000 3 John Smith 45 2000 4 J. John 40 2800 Update Sheet...

I have a spreadsheet like the one below. I want to be able to create a macro or formula to remove rows of data that have less than 3 matching names. Example: I would want something to be able to remove Doe,Jen...Matthews, Sarah...etc...My excel sheet has over 700 rows that I would have to go...

I am hoping someone can guide me in the right Direction, I have got the basics of Vlookup, but want to take it a stage further I have two sheets with identical entries in columns a - c A= Organization Name B = User Name C = User Email <tbody> Organization Name User Name UserEmail...

This is half of a formula I have..... =20-SUM(COUNTIFS('All Worker Time Off'!$C:$C,"john smith*",'All Worker Time Off'!$D:$D,”Time Off Request)) I need it to start at 20 and minus 1 for every time it finds, in the "All Worker Time Off" sheet, john smith in column $C:$C and also finds "Time...

I would like to change names formatted like this: John Smith to this: Smith J Thanks for any help, Doug