General

Calculate parts per hour on rotating line
There is a 700 feet rotating conveyor. Moving at a rate of 7.5 feet per minute. I know it takes 93 minutes to make one revolution. How long will it take to get 500 parts off the line? The parts are spaced 1 foot apart. I need a formula that can calculate this. Can somebody help me? ... 13 Apr 2010 16:13

Return value greater than in LOOKUP
I am trying to use the lookup function to return the next value greater than the lookup value in a vector. However, the only thing that the lookup function will do is return the next value that is less than or equal to. Is there a way to get it to return the value greater than. I am using: LOOKUP(25.4,M10:M... 7 Apr 2010 14:40

Microsoft 2007 Excel quirks with Charting
Has anyone had this happen to them yet? I have created an SPC line chart with my data. I add my titles, logo, copyright info, etc. Everything looks great. I save and close it. When upon opening it again, everything within the chart is distorted. The Y axis is about 1" high, the images and copyright I inserted are... 7 Apr 2010 12:23

convert to minutes
Good Morning Is there any way I can convert following to minutes using a formula or any other way? Thank you 35 Min 1 HR 2 Hr 30 min 2 Hr 5 min 2 Hr 5 min 2 Hr 30 min 1 Hr 10 min 2 Hr 2 Hr 15 min 3 Hr 5 min 1 HR ... 7 Apr 2010 14:40

Patient Demand on X Day of the Month
I need to summarize and compare patient demand for appointments going back over three years. I can pull the data and display the days of the week. In Ms Excel, is there a way to line up the same days of each month - but not the dates? For instance, I need to line up and average all of the first Mondays in Ma... 7 Apr 2010 14:40

If Statement with 9 sequences
Hello everybody, I currently have an IF statement w/8 sequences and it is working properly. I'm doing this for tax purposes. When I try to add one more sequence, it doesn't work. basically I just want to say If B4<529,0. I want it to return a value of zero if cell B4 is < 529. Please help!!! Thanks! Da... 7 Apr 2010 12:23

Excel
When I type a line in Excel the printing gravitates to the top of the line and not the bottom. How do I change that? ... 7 Apr 2010 12:23

Lookup for Part of the number
Hi, I need to lookup for a Loan Number from another sheet. However the problem is sometimes one digit would be added to the end in the other worksheet. Is there a way to find match for this digit.For the digits in below list I need to get the match as true for 12345 and 12346 as there is 123451 and 123462 in ... 9 Apr 2010 07:48

clean up code a little
Hi I have a copy and paste code I was wondering if there is a way to clean it up a little to run it more better. Here's my code. Sub ApplyStock() Range("C3").Copy Sheet4.Select Range("B7").Select ActiveSheet.Paste Sheets("Stock Maintenance").Select Range("C4").Copy Sheet5.Sele... 12 Apr 2010 14:48

Index/Match vs VLookup?
Excel2003 ... My understanding is ... an array "Index/Match" Formula calculates faster than a "VLookup" Formula ... If so, then I would like to use "Index/Match". Also, I often do use "Index/Match" as the Index can be either R or L of target cell. Issue ... with 2 Cols of 40,000 records ... Index/Match Fo... 7 Apr 2010 15:47