peter

  1. T

    Lookup and return all values in a row

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

    Sumifs rolling total - calculation not adding up

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

    Determine if date is within range

    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 } -----------------------------------------------------------------...
  4. S

    Unique name list

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

    Highlighting duplicates in rows

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

    Calculating hours between columns

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

    Search Folders for Partial Name

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

    Calculate with rows filter

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

    Delete duplicate data in Column I leaving just one unique row

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

    "sumif" help

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

    Dynamic Range Expansion (No VBA)

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

    Dynamic Range Expansion

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

    Pivot Chart

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

    Sequential numbering based on change in another column

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

    RANK Formula with Criteria

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

    transpose data query

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

    Vlookup in a querry?

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

    Is there a way to paste a string value into a cells in a single column, a certain number of words after?

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

    Return the value of a header row if cell contains data

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

    Remove duplicates based on multiple criteria (ID and Date)

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

Some videos you may like

This Week's Hot Topics

Top