john

Hi, I have a table that we use to help schedule employees and want some type of warning if we double book them. It is setup as such: <tbody> A B C D E F G H I J K L M N 1 Name Job# Loc 6/25 6/26 6/27 6/28 6/29 6/30 7/1 7/2 7/3 7/4 7/5 2 John A X34 USA D D D D D D D D D 3 Joe V45 CAN N...

<tbody> <tbody> Day Descr2 Name Start time End time 6:00 - 7:00AM 7:00 - 8:00AM 8:00 - 9:00AM 9:00 - 10:00AM 10:00 - 11:00AM 11:00 - 12:00PM 12:00 - 1:00PM 1:00 - 2:00PM 2:00 - 3:00PM 3:00 - 4:00PM 4:00 - 5:00PM 5:00 - 6:00PM 6:00 - 7:00PM 7:00 - 8:00PM 8:00 - 9:00PM 9:00...

Hi The data I'm trying to consolidate has this structure. I found pieces of code around the forum but i just can't make it work, is there a way using VBA or a formula I can do this? Make this: <tbody> A B John 1 apple 2 apple 1 orange Peter 1 Lemon 1 Orange 2 Lemon 3...

hi, i am trying to do some macro on an existing report in excel - its a client account statement - if the client has multiple accounts it will seperate them out into sheets and name each sheet for example John, John 1, John 2, John 3, john 4. depending on the client there could be 2 sheets or...

Hi I know pivot table can bring the result but I need formula to bring unique name list in column B from list of Names in column A, please share any formula Column A John Ben John Ben Ben John Peter Peter Column B John Ben Peter

Hello, I have a list of names in 1 table and a list of names in a 2nd table. I want to highlight every line in the second table where the person found in the first table, however there could be extra words added to the names in the second table. Example: Table 1: John Doe Jane Doe John Smith...

Hi everyone, new to the forum and would like some guidance on some formula i am stuck on: we have a large dataset which has some info re staff absence days , and looks like the below. what i am looking to do is increment by 1 each time the staff member in question is registered as being absent...

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

Hi, is it possible to get a pivot table to display a text value (persons name) multiple times? For example, I enter a persons name, 'John Smith', and a number '225588'. If John smith or another John smith information is entered again the pivot table automatically combines the name as one, John...

Hello, What formula can i use to count the number of individuals joining by month and year in column E. I've tried the formula below however get a value of Zero =COUNTIFS($Q$16:$Q$4007,MONTH(6),$S$16:$S$4007,YEAR(2019)) <tbody> a b c d e 1 6 2019 john June 2 6 2019 jacob May 3 5...

I have a spreadsheet that contains multiple rows of data for multiple dates and companies. I am looking for a way to show all of the entries for the specified company within a specified date range. For example, I want to see all of the entries for company ABC between 1/1/2019 and 1/5/2019. I...

Dear Friends, Calculating Commission: Main sheet: Cells A1 to H5 <tbody> SALESMAN SALESMAN NO BILL NO BILL DATE SOLD AMOUNT PAYMENT RCVD BALANCE DAYS JOHN 20 AF-001 02-04-2018 1000 1000 0 10 JOHN 20 AF-042 14-04-2018 2000 2000 0 20 JOHN 20 AF-050 29-04-2018 3000 2500 500 12 JOHN 20...

Hi, I am trying to extract text from a cell to reformat and remove some parts. Jones, John (London) would want to be changed to John Jones I have tried using the LEFT/RIGHT/MID and SEARCH formulas but i have not been able to tweak it to correctly show what i want. Can you please help

I would need to have the formula to reflect the below match in colums C Thanks <colgroup><col width="70" span="3" style="width:53pt"> </colgroup><tbody> ID Name Match 88100 james TRUE 88100 james TRUE 88100 Mick FALSE 89100 John TRUE 89100...

Hi. I have a Userform that some users complete to update info on a (large) table. I've added a bit of VBA to get the date added when the user who has opened the spreadsheet makes a change to the database but I'd like to be able to add their name too. However, when I use Application.Username I...

Hi, Please can someone help? I am trying to create a list from a master list based on a criteria. Below is an example https://www.dropbox.com/s/ui61g35ycc...nshot.jpg?dl=0 Basically, I want to create a list from the master list in row A & B I want to use the account manager name in cell D3...

Hi, Please can someone help? I am trying to create a list from a master list based on a criteria. Below is an example https://www.dropbox.com/s/ui61g35ycc7em0u/Screernshot.jpg?dl=0 Basically, I want to create a list from the master list in row A & B I want to use the account manager name in...

Hi, Not sure if vlookup is the correct thing to use for this but i have data like below: <tbody> Name StartDate EndDate John 12/05/2019 15/05/2019 Luke 14/05/2019 14/05/2019 Anna 11/05/2019 16/05/2019 Alex 14/05/2019 16/05/2019 </tbody> Now for example if a have a sheet with dates if...

Hi guys, I have a spreadsheet with multiple customers and price they paid for different items. I am trying to find what percentage they spent on each items Can it be done with vlookup? Here is an example: <tbody> Name Item Price Percentage Breakdown John apple 2 Tom apple 3 Amy apple...

Here's an example: <tbody> John apple John fridge John heart John pear John car Steven soap Steven display Steven pen Steven orange Steven bee </tbody> I would like it to look like, <tbody> John apple fridge heart pear Car Steven soap display pen orange bee...