Threads Replies Last Post 189 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>   Calif OT Calculations I have the first 5 days. I need the 6th and 7th day. If they have less than 40 regular hour on the sixth day, then its regular up until 40 then 1.5x. Same thing applies to the seventh day 48 hours. A work day consists of at least 8 hours. One and one-half times the employee's regular rate or pay for all hours worked in excess of eight hours up to and including 12 hours in any workday, an... 8 5/23/2007 7:13:16 AM Conditional Paragraphs OK. Thanks to the support received here I got Conditional Dropdowsn working nicely. Now I need to fill a cell with a paragraph of text depending on a dropdown list selected elsewhere e.g. If I select Apples from a dropdown list of fruit, in another cell I get a paragraph telling me about apples. Thanks Mike ... 4 5/23/2007 5:14:44 AM Need to pad with Zeros to the existing list of numbers in a column I have some values in a spreadsheet and I would like to pad with zeros to the right side. For Ex. 1224 should be converted as 01234... 2 5/22/2007 9:53:15 PM how can meak zip cod i cant make zip cod for contenio... 4 5/22/2007 9:04:16 PM Take formulas out I want to take all my formulas out the the worksheet and just display the values... 7 5/22/2007 8:27:23 PM Compatibility Mode I recently installed Excel 2007 and notice that many of my files are running in Compatibility Mode. What does this mean and how do I stop it from doing that (if I even want to)?... 8 5/22/2007 7:34:46 PM Merge How do I merge? lables, envelopes and letters... 2 5/22/2007 6:39:15 PM selected cells doesnot change colour I want the excel cells to change colour as I select so I could see the range I have selected as it was in previous versions. How I can select this option. ... 10 5/22/2007 1:45:20 PM Inputting a length of time? Hi I am trying to calculate depreciation in my Excel spreadsheet. The depreciation is over 60 months, so for a $6,000 item, the formula is =$6,000/60 = $100 The problem I am encountering is making that calculation stop after 60 months. So in month 61, the cell reads $0, instead of $100. Is there anyway in Excel to 'time limit' the effectiveness of a cell's formula? To make it even... 13 5/22/2007 10:49:51 AM conditional sums and multiple criteria Please help: I'm working on an award tracking system for individual girl scouts and a summary sheet that lists if each scout earned an award and the date it was awarded. I'm trying to calculate how many awards to purchase and need to count the number of completed awards only if date awarded field is blank. I've tried COUNTA, SUMIF, and keep coming up with errors. Do I need to combine functions? If... 2 5/22/2007 4:40:49 AM I would like to type one word on top of the other in Excel i Would like to type one word on top of the other. Example: " Sales Commisions"... 4 5/21/2007 8:06:59 PM excel Is there a way to fill a column from a different sheet and the next day fill the next column over from the same sheet as that sheet is updated by a data base daliy. I want to keep the information in the first column and continue to move to the next column each day. ... 3 5/21/2007 5:10:28 PM Conditional Drop Downs Could anybody please advise me on the best way of having conditional drop downs. What I would like is a drop down for my first column that selects from a list of manufacturers and then from that selection, select a list of appropriate colours from that manufacturer. This list of manufacturers is less than 10 but the list of colours per manufacturer is about 50 Thanks Mike ... 4 5/21/2007 3:09:57 AM Table of valid codes This is a common function in application systems, and I am sure there is a simple way to do it in Excel, but so far I haven't been smart enough to figure it out. I have a column of account codes on Worksheet 1. I want to be able to select a code cell, open Worksheet 2 containing one column for all valid codes and one column for the descriptions, select a code from Worksheet 2 and ha... 9 5/20/2007 10:12:44 PM Slow Opening & Odd Closing I just instand Office Standard 2007 over Office Pro 2003. Now when I open an Excel file the Excel window opens, then it takes a very long time before the file opens. When I click on the "X" for the Excel window - not the "X" below it for the open file - the file closes, but the Excel window doesn't close until I click the "X" again. This works nothing like the Excel 2003 files. Can a... 2 5/20/2007 4:28:51 PM Merging Colums Hi i have a sheet with data in the following format Column1 Column2 Column3 etc Y Y Y I need to changed the Y's to different values. In column1 Y needs to equal = 1 and in Y in column2 needs to equal 2 etc. Is it possible to change the values other than having to change each Y indvidually? I have 70... 18 5/20/2007 1:01:01 AM transfer exel report to a usb flash drive F transfer exel doc.to new flash drive 2.0... 8 5/19/2007 8:41:00 AM conditional formulas I've done all the searches online and off for help. Now time's running out for my project. Here's the situation... My data is in two columns with thousands of rows, columns are Parcel Size in Acres (number) and Use Code (numeric text). There are probably a couple hundred different use codes. I would rather group the more detailed use codes into broader categories, then get those tot... 3 5/18/2007 11:25:00 PM Can I undo something saved to restore a document? In excel, I typed info that went from A to Y. I moved the cells from V over to D so I could type the info in A and B on the end of the doc. I needed to see A and B, then everything between D and V was hidden. After I finished, I forgot to move the cells back, and I saved the doc. Can I recover or undo more than it's allowing me? ... 2 5/18/2007 8:49:16 PM merge cell data merge three cells... 3 5/18/2007 7:58:48 PM stupid question i have a spreadsheet that the last person working on it put last name and first name in the same cell i would like it to have a last name column and a first name column. is it possible to split the contents with out having to retype it all. P.S. there are over 1000 entries ;O)... 5 5/18/2007 7:55:07 PM can excel make a serialized list automaticly? if I say start a column with 000001 is there a way to make it continue this etc 000001 000002 000003...and so on?... 5 5/18/2007 5:58:57 PM Data Entry Mini-Project Folks: I have a 6-column spreadsheet which I would like to SHARE with some other users (simultaneously) to complete a Data Entry task. The columns have headings: Name, ID #, Age, Height, Weight, Birthdate. Each person is responsible for completing a different column of information. Each person is only allowed to sees the 2 columns of information: (ID #) AND (Age OR Height OR Wei... 2 5/18/2007 2:52:00 PM Returning an Array from a called function within a macro How do I get a function to return an array. [I know that it should be doable since the various matrix functions return an array.] To be more precise I need to do this within a macro. I know how to do it at the spreadsheet level. I am running Excel 2004 on a MAC [OSX] Thanks Brujolito ... 2 5/18/2007 2:47:32 PM cell formatting I need to have 04/03/07 displayed in the cell as 040307 no dashes ... 2 5/18/2007 11:52:45 AM 189 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>