Search results

Hi all -- I work at a plant that bottles milk and juice. Every day I have to generate a very time consuming report from all of the previous day's work. This report is generated from a DB we utilize and has 400+ rows from weight samples taken through out the day. The question I have is two...

Hi all -- I have a large spreadsheet that I print out on a ledger 11 x17 size paper and for some reason, Excel has decided to get rid of this size paper in printer setup. I made sure to have the paper loaded but it either doesn't give me that size for a choice or it prints a forth of the...

Hi all - I am working with times of job completion (not time of day) and have a column formatted hh:mm. When I sum it or average it, I only get a number < 24 hours. I have tried to over ride this by doing =if(mod(sum(range), 1), sum (range), sum (range)+24) with no luck. With the average...

Hi all -- I love this site -- have learned ALOT from it, but now I have to learn ACCESS. Can anyone recommend a blog for ACCESS that is close to as good as this one (though when you are the best; there is no competition ;))? If any of you are ACCESS trained, this is the first hurdle I have...

Hi all -- A friend asked me what the best way to link together 5+ network workbooks that different people use throughout the day. There is no guarantee that all the workbooks will be open at the same time. I thought if we had a "bridge" workbook that is always open (can that be stored on the...

Hi all -- First thank you to SirJB7, without your help on a different problem I would not be this far. I have a table 10 columns and 25 rows -- odd numbered (*see below for why I am not saying Column A,B,C etc.) columns have a sequential number, while columns have a factor of 0.015 starting at...

Hi again -- The second question about looking things up in a range is more complicated. On a different problem than part 1 I have the ranges of: 100,000 - 120,000 lbs. --> 0.25 120,001 - 140,000 lbs. --> 0.30 140,001 - 160,000 lbs. --> 0.35 160,001 - --> 0.40 The way this...

Hi all -- I have a situation where in Cell A1 there is a set value. When I enter a value into Cell A2, I need it to lookup a chart of values determined by a range for instance 0 - 50,000 gives a multiplier (acting on cell A1) of 0.80, 50,001 - 100,000 gives a multiplier of 0.70 100,001 -...

Hi all -- I have a workbook that has 30 tabs, each worksheet represents one day of the month and is basically the same throughout, though some worksheets have extra rows000. Each worksheet has approximately 450 rows and in column G product information is recorded if a certain product (shown...

Hi all -- I have a spread sheet with individual's id number on the left column and test scores (if available) under each month. I would like to automatically color the cells if 3, 4, 5, etc. cells have a value entered in a row. (see attached) I have played a little with the information...

Hi all - I have a rather large spreadsheet with LOTS of equation. I would like to email just one worksheet to a client with no equation available and only the numbers / values in the cells. Any thoughts? thanks Lawrence

Hi all -- I have a spreadsheet with some attached graphs. I thought if I made a copy of the spreadsheet then the formulas for "select data" would be for the new sheet instead of the master copy, but it keeps using the master copy to generate the graphs. Any thoughts on how to make the "select...

Every month I copy a large spreadsheet with 8 charts created by the monthly input. My question is I would like to have the charts on a seperate sheet so that I don't have to scroll to the location of the charts to print. How can I make a data sheet and chart sheet that are created at the same...

Hi all-- My co-worker asked me if I could come up with a good way to chart some data. Here is the scenario: We run four shifts and are trying to graph "# of units ran" and also (separate chart if necessary) "lbs of product ran" per shift in a month's time then a chart with the totals of each...

Hi all-- I am trying to build a graph of total time our machine is down per week. In column A I have the different weeks ie 20 May - 26 May, 27 May - 2 Jun, etc for the last 2 months. In column B I have the total times (summed from another part of the sheet). My problem is that when I try to...

Hi all-- I am trying to determine busy times vs. slow times. I have a spreadsheet that has 1 Oct to 27 Dec as column headers, each column as a list of times that a test was done on that day. Some days the test was run 5 times, some day 100 times. I am trying to graph what times are the most...

HI Luke-- Thanks for you forensic analysis of the fruit / vegetable question. My question is this: what if you wanted to list the fruits instead of the vegetables? My colleague and I tried changing the criteria and nothing, tried making the &#60; ROWS into &#62; ROWS and still nothing...

Hi all-- Thank you for your help last week on finding sub totals from a huge list. I got =SUMIF($I$5:$I$66,$N38,$H$5:$H$66) to work as far as giving me the times of each category, now when I try to insert a graph from this information, I just get the total time for everything in one bar...

Hi all-- I have a spreadsheet that calculates down time on a machine (G#-F#). The time is in H# and the reason is in for the down time is in I#. I tried =SUM(IF(I5:I60="Heaters",(H5:H60),"")) to figure out the total time the machine was down due to the heaters, but it didn't work. I would...

Hi all-- We are on a 24/7 schedule where I work with 4 teams A-1st, A-2nd, B-1st, B-2nd. We have a spreadsheet with a timestamp (mm/dd/yy hh:mm:ss). Currently I use this: =IF(MOD($A6,1)&#60;VALUE("5:00"),2,IF(MOD($A6,1)&#60;VALUE("17:00"),1,IF(MOD($A6,1)&#60;VALUE("24:00"),2,""))) which...

Hi all-- I am working on a large MONTHLY inventory sheet with 400+ rows. In column AM, a letter is displayed based on amounts found elsewhere in the workbook. "A" for over 10,000, "B" for 5,000 to 10,000, "C" for under 5,000 and "D" for under 100. This is a dynamic letter which changes month...

Hi all-- My colleague thinks I am an Excel genius (he just doesn't know I am a member of Chandoo.org :) ) He asked me for help on this scenario. He has a large spreadsheet with lots of inventory data. When the actual count is outside a certain range compared to the projected count (plus or...

Hi all-- I have a spreadsheet that makes a time stamp when a cell is filled. The time stamp is in the form MM/DD/YY HH:mm (with 24 hour time). In the next column I need to be able to say if the time is between 07:30 - 15:30 then a 1 is displayed (for 1st shift), if between 15:31 -- 23:30 then...

Hi all-- Can anyone give me some advise on this. When I hit the Enter button, the cursor goes to the next row (that is good) but it doesn't go to the same column (that is bad); I would like it to go to the first column everytime without having to hit Home. Any thoughts:) ? Thanks LCD

Hi all-- I built a macro to sort out a section of my spreadsheet (thanks for the help), what I could not figure out is how to have the macro put the cursor in the first blank cell in the first row. What do I have to do to go to the end of the line automatically:)? LCD