Search results for query: *

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

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

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

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

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

I have a data set that is linked to a group of charts. I would like to be able to adjust one chart and change another. Everyting adds up to a certain number. Lets say the number is 200 widgets and my data set contains 50 widget 1 which is 25% of the total widgets 60 widget 2 which is 30%...

I am trying to place a Microsoft Access form on my company intranet that will update a database. This will give individuals the opportunity to have the form in one place at all times and still update the database that reports will be run from. Thanks in Advanced D

I have two data tables, like the ones below. Group 1 USER ID FIRST NAME LAST NAME AAA0QTB AARON ADAMS AAA0QTB ALEX ABRAMS AAC0P7Y ADAM CARTER Group 2 GPMEM_NAME GPMEM_MEMBER_ID USBD_PROGRAMMER GROUP02B AAA0QTB GONZALEZ, ALEJANDRO...

I can see my code with no problems. However, when I want to see the webpage in design view it will not let me. I am editing the page for someone else. How can I see my table in design view. Thanks in Advance

I am trying to edit a html web page in dreamweaver. At first I was editing just fine. Then everytime I try to view the webpage on the internet. I get an error message stating You have made changes to a code not marked as editable. Then they keep going back to when I did not make the change...

I have ran some queries to compute averages. I need to be able to create a report using these queries but I cant put them on the same report because the data comes from one table. I have different queries Instructor Average query Alfred 3.4 James 3.5 Brian 4.2 Steve 4.5...

I have a table that holds information about different instructors and there ratings that were taken by a survey. I want to run queries that would give average scores for each person for all of its classes. The table looks like this: Instructor Course Rating 1 Rating 2 Rating 3 Joe Green...