Search results for query: *

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

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

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

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

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

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

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

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

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

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

It appears to have worked. Thanks for your help!

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

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

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

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

I am trying to create a form using excel that uses a validated list. The list comes from a named range that is from a data set that is maintained in the same workbook. The problem is the data worksheet has repeat values. Like This Operation 111 112 111 112 115 116 112 I would like the drop...

I have a sheet with data containing different machine names. I want to find the average of each machine by name and input the average values into a bar chart in excel. The data looks like this Machine 1 5 Machine 2 4 Machine 3 6 Machine 4 3 Machine 2 5 Machine 2 6 Machine 1...

I have a sheet within excel that contains data in columns such as Technology type and different types of products from that technology. The data sheet looks like this: Technology Process Number Product 1 Product 2 Product 3 Tech 1 1 15 30 45...

They all have the same data range, however if I want to change one chart, I have to manually change the rest of the charts to maintain consistancy (maintain of total of 200). I would like to change all of the charts when I change just one of them. I hope this clears this up. Thanks for your...

Yes that is the case. I would like the value to always equal 200. Do you have any suggestions?