jack

Dear All, I have the following names in a row like below <tbody> #FFFFFF[/URL] "]Sam #FFFFFF[/URL] "]John #FFFFFF[/URL] "]Jack #FFFFFF[/URL] "]George Paul #FFFFFF[/URL] "]Mathew Joy </tbody> and I have a table on another sheet where I have the following data, <!-- Please do not...

Hi I want a formula to pick 1st word from the sentence , please help Jack & Jill = Jack Please come = Please Gross Margin = Gross

I have a simple table showing a list of golf scores with the name of the person and the date of the round. From this list I want to be able to put in a separate table the date and lowest score of each of the players Name Score Date Name Date Best Score Terry 73 01/05/2019...

I'm working with a long list which is a bunch of names in one column - they are in teams of a maximum of 5, but usually less so I need to create blanks rows to keep things in order: Column A/B is what I need to achieve - from the basic list I get in column E... <tbody> A B C D E...

What is the easiest way to count cells with the same value, across columns? <tbody> A B C D E F G Jack Jill John Jane 4 Jack Jack John John 2 Jill Jill Jill 1 John Jack Jack Jane 3 </tbody> The first 4 columns have names as above, and column F has the...

I have the following code which triggers when the user double clicks on a field: Application.FollowHyperLink "http://www.google.co.uk/search?q=" & BusinessName This works fairly well and opens Google to search for the value in the BusinessName field. However, some Businesses contain "&" -...

Column A has an Employee Name Column B has a Date An employee name can repeat on the same date I want to know by month the sum of the count of the number of unique names each day. John Doe 4/2/2019 John Doe 4/2/2019 Jack Smith 4/2/2019 John Doe 5/1/2019 Jack Smith 5/19/2019 Jack Smith...

Hi everyone, Apologies I seem to be stuck on what I thought would be a simple formula. I have a large dataset of customers taking flights (one ways in the dataset) and I am trying to calculate how many are 'most likely' round trip flights (matching by customer name then origin to destination...

Hello, i need help in this please <tbody> <tbody> name </tbody> <tbody> type </tbody> <tbody> Jack </tbody> <tbody> iphone </tbody> <tbody> Jack </tbody> <tbody> android </tbody> <tbody> John </tbody> <tbody> iphone </tbody> <tbody> John...

I have raw text data in cell A1 I also have list of words that I want to be bolded to that cell. (These words are listed in column B) I want it to be like this: Bold every "Jack" and "John" in cell A1: Jack and John are brothers. Jack is older than John. Jack likes football but John hates...

Hi I need help on this. I have two column A & B A1 B1 C1 (concatenate result)-Bold and Italic Happy Family Happy Family May I know what should I do? Thank you Jack T

Hi all, I have the following data in the range C1:D15 ... <colgroup><col><col></colgroup><tbody> Original Email Barber, Isabella (59792) melissa.barber@bigpond.com Barber, Isabella (59792) robert.v.barber@hotmail.com Bell, Maya (83298) gaye.grahambell@bigpond.com Bellamywells, Lewis...

I have a basic Table of Projects similar to this: Project Name Month Proj01 Bob 1 Proj01 Bob 2 Proj01 Bob 3 Proj01 Jack 4 Proj01 Jack 5 I can take table out to excel and add Min & Max formula to present as: Project Name StartM...

Hi Team, I have a below data and we would want to know how many time word P has repeated continuously for each name. I have give the result which I require for Jack it should be 4 (Its repeated 4 times continuously) and for Jill it should be 2 (Its repeated 2 times continuously) and for James...

I have sheet1, where there is a table in below format. <tbody> A B C D E F G H Prop ID: Leads ID: Caller Category: Duration: Type: Name Date Link ONI10P07 7631565 Prospect New 5 Phone Jack Hill 09/04/2018 www.google.com ONI10P07 7631578 Prospect Followup 20 Phone Jack Hill 09/04/2018...

Hi All Can anyone help me please with a formula for the following example. Ideally, I would like a regular formula, but if this is not possible, then a UDF would be much appreciated. I have the following in columns A, B and I would like the result to be as per column C (Owner Name) :-...

So I have been trying to do a supercharged vlookup. where it could match a part number on one sheet, with the one on another sheet ( after both have been trim and matched in format ) and return all the drop locations. Well the array that worked the best, crashed Excel and would run too long. So...

There are 4 excel sheets in a workbook and every sheet has huge data i.e. datewise productwise sales details Now i want get the below details in 5th excel sheet i.e. total sales of specific product in specific time by using VBA code as every sheet has atleast 4-5 lakhs data Why i'm asking...

In a program I wrote many years ago I have this code #If vba3 then some code here #end if What is #If vba3 tia Jack

Hello, I been whacking my brain on this little problem for a few days now and about to cry So i have 2 tables Table1 <tbody> Month Name Hours 1 Joe 3 1 Jack 4 2 Joe 5 2 Bob 3 2 Nancy 6 3 Jack 4 </tbody> Table2 <tbody> Name Jan Feb March Joe x Jack Bob Nancy...