Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by deante

  1. deante

    Sum cells based on Time and Category

    The second formula worked. However, I want the cells that are not first one. to have no value. Im trying some other formulas but have had no luck
  2. deante

    Sum cells based on Time and Category

    The results should be within 3 hours of the first event of that Cause 1 type. For the data shown, the desired result is below. Notice how the flavor changes were not combined because the time between events is over 3 hours. I am trying to combine events that have been broken out into seperate...
  3. deante

    Sum cells based on Time and Category

    I hope all is Well! I have been trying to come up with a worksheet function that would eliminate some tedious data crunching. I need to sum the Duration (column D), if column A and Column B are matched between the the rows. Th tricky part is they only need to sum if the start time are within 3...
  4. deante

    Create Filter based on users selection

    I am creating an application for my company that is a parts list. The goal is for maintenance techs to find part numbers quickly rather than looking in a manual. I have a long excel file that is has the following headings: Line MACHINE Area DRAWING # PART # Description I want to create...
  5. deante

    using Sumif to sum particular values from a data table

    Sorry it took so long for me to get back, I used xlbo's tip and it worked great thanks for everyones help!
  6. deante

    using Sumif to sum particular values from a data table

    Hello All, I am trying to sum cells that are in a table based on criteria from a different column. Here is an example of what my data looks like. Tech Day A 15 B 20 B 10 C 55 B 20 A 25 B 25 I want to sum the day values...
  7. deante

    Lookup value in one column and return value from another

    Hello all, I am trying to reference a cell and match the value in that cell to a value in that column and return a value from another column. The Lookup function does not seem to be working. Heres a sample of my data. Sector Type Week Tool D M 2 GB C M...
  8. deante

    Creating individual cells for a cell with long text

    Hello all, I have copied a table from the internet into excel. However, excel treats each row of the table I copied and puts it in one cell for each row. I need certain information on the table from the internet to do some data analysis. I used the MID function to put the long text into their...
  9. deante

    Match time from one column to another

    I've tried what you suggested an keep receiving a #NUM! error message? Any other ways?
  10. deante

    Match time from one column to another

    Hello All, I know one of you all can help me with this problem. I have a worksheet with six columns. Tool, Start, End, Tool, Auto Start, Auto End. The sheet was made from two other worksheets. I want excel to search the worksheet for matches where the auto start and auto end time are within the...
  11. deante

    Autofill with the Vlookup function

    It appears to have worked. Thanks for your help!
  12. deante

    Autofill with the Vlookup function

    Sorry I did not explain. Because that particular value may not always be in that cell. One day the data could look like this: Type Step Rate Next Day Rate 1 51 40 1 50 30 40 1 49 25 30 1 48 35...
  13. deante

    Autofill with the Vlookup function

    I have a data set that uses Vlookup functions to retrieve a value from the row above it. Here is an example: Step Rate Next Day Rate 50 30 49 25 30 48 35 25 47 20 35 etc etc I could manually do the Vlookup functions but there are...
  14. deante

    Is this possible in Excel?

    Only the operations are constant, The min amount and Total Amount of Operation are pulled from a data sheet that changes often. Also, you will hard enter the max value each time you want to adjust the min amount. Thanks for your help
  15. deante

    Is this possible in Excel?

    I have been trying to create a sheet in excel for a while. I am have a large set of data in one sheet that contains column headings for each set. I would like to take this data and create charts for each different operation. Each operation chart will have the same information, just for that...
See more

Part and Inventory Search

Back
Top