peter

I have a table that follows the same structure as below. Note that in my document it is a very large table (150 rows, 30 columns), so I would like to keep the general formatting of it. <tbody> Bob Table Peter Bed Couch Chair Jeff Bed Table Grace Couch Chair Tom Bed Couch...

Hi, I am trying to do a running total based on Date and Hours. The end result that I want (table A) is the "rolling hours" column. Table A DATE Person Hours Rolling Hours Tue, 05/28/19 Peter Pan 12.06 12.06 Wed, 05/29/19 Peter Pan 4.97 17.03 Sat, 06/01/19 Peter Pan 12.10...

I have beat my head against the wall with this one. I really hope someone can help here. To Completely summarize what I am trying to do.... { If it is Peter's pay-week, N4 equals Y1 If it is Casey's pay-week, N4 equals Y1 + Y2 } -----------------------------------------------------------------...

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 spreadsheet with 15 columns and over 700 rows. I would like to highlight duplicate values within each of the rows. There may be more than one duplicate. I have copied some of the data below. For example Southampton and St Peter Port may be duplicated on the same row. I would...

Hi Team, I have below data and I would require a formula to see how many activity each person has processed in an hour, for every hour I would like to show the progress in different table. I want to see the progress for 12 hours. I input the processor name in column A in sheet 1 and 2 to get...

Hi - Is there a way to search folders to open by matching just a partial folder name. For example: I want to use cell C1 as a reference for the folder name. So while C1 has the text "Peter Piper Picked", and the folder on the drive is titled Peter Piper Picked (12 Pickles), it would still...

Hi All, Very new to Power tools . i have been experimenting on this issue which i can deal in Sumifs. How can I show in Pivot table that Mark has 30 total, Ricky 15 Total, Peter 18 Total and Gino has 5? <tbody> 10 ID01 Mark 15 ID02 Ricky 20 ID01 Mark 10 ID03 Peter 5 ID04 Gino...

Hi I'm using excel 2016 i have a spreadsheet with 56,000 rows and in column I have i have a set of data that is duplicated i would like to delete the duplicates... however i need to retain the very last row of the duplicate as an example i have highlighted in red below ( the data is just a...

Hello there, Please assist Please I need a formula that reports how much cookies James sold between <tbody> 03/01/2019 and 09/01/2019. See table below <colgroup><col><col><col></colgroup><tbody> <colgroup><col><col><col></colgroup><tbody> A B Salesman Cookies...

Hi I want to dynamically expand my data as follows without using VBA. I have text data in a single column. There is no empty cells in between the data but the number of rows having data can vary. <tbody> Names John Sam Jessica </tbody> I want my result as follows. <tbody>...

Hi I want to dynamically expand my data as follows. I have text data in a single column. There is no empty cells in between the data but the number of rows having data can vary. <tbody> Names John Sam Jessica </tbody> I want a dynamic result as follows. <tbody> Matches...

Year Month Salesman Customer Name Category Sales 2018 Target for Jan 2019 2018 Jan Peter A Supermarket Milk 20 22 2018 Jan Peter A Supermarket Cheese 30 33 2018 Jan Peter A Supermarket Juice 15 16.5 2018 Jan Peter B Supermarket Milk 15 16.5 2018 Jan Peter B Supermarket Cheese 17 18.7 2018 Jan...

HELLO, I'M TRYING TO GET A FUNCTION FOR A NEW COLUMN (COL 'DP') TO ACHIEVE THE RESULT BELOW. i CANNOT FIND A WAY TO DO THIS. i AM TRYING 'COUNTIFS' BUT ITS NOT WORKING. i HAVE A LARGE FILE, AND EACH TIME THERE IS A CHANGE IN COL A, I NEED THE NUMBERS TO START AGAIN FROM '1' IN A NEW COLUMN. I...

Hello Friends, I need a Rank formula based on criteria Here is a sample data (having Names in A2:A8 & Qty in D2:D8) NAMES Qty <tbody> Peter 25 John 99 Mike 36 Mike 25 John 48 Peter 99 Peter 2 </tbody> Required names (rank wise) based on sum of Quantites in Column D...

i have been working on an efficient way to get this excel data to transpose in the way that appears underneath it, at the bottom of the post the way i do involves several steps and its painfully slow, and the data set can be large, and as i need to do it 3 times a week, I'm hoping for a faster...

Hi, I have a table of employees (TblEmployees). I use their ID key to link to whom they supervise EmployeeIDName SupervisorIDSupervisorName 1 John 2 Peter 2...

Sorry for the confusing title, perhaps an example better explains what I am trying to do. If I have a list of cells that contain sentences such as : A1 Mary Jane listening to music A2 Peter Parker doing homework A3 Eddie Brock eating pizza and I would like to add a word after their names...

Hi all I have a list of names in a column A and a list of categories Cols B-F Each person can be tagged to several categories with the value of either 0 1 2 3 or 4 I am after a way to create a separate summary sheet that will tell me the person’s name in one cell (which I can do with...

Hey guys! I'm working on a project that requires merging data from multiple workbooks into a single "master" workbook. All files have the same number of columns and have been merged properly. That means all data is in the "master" workbook. I couldn't manage to remove the duplicates though...