Threads Replies Last Post 837 Pages: <<  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  >>   conditional formatting Hi there, I am trying to use conditional formatting to turn the cell red if the value is not a dividend of 3...any suggestions would be great!... 6 20.09.2006 06:34:01 Compare Two columns Hello, I tried to figure this out, seems to me that I'm getting close I need the formula to look at column AA see if it says O or U, then look at Column AB and see if it says O or U, then if they both meet this criteria, then return 1 in AC, this is what I have so far, =IF(OR(AA26={"O","U"},AB26={"O","U"}),"1",""), I'm probably off, but it seems to have started to do something. ... 5 20.09.2006 05:20:22 How do I create chart that show percentages for 1 and 0's? I am trying to create a spreadsheet that will show our companies %s, on closing calls within a timely manner. I have an example of a list but am looking for help on how to complete this project? Can anyone help me?... 1 20.09.2006 04:03:01 allow users to edit ranges Hello, I have a workbook/worksheet(?) which I need to share and allow multiple users to edit specific ranges only. I have attempted to follow the process as outlined in "TOOLS>PROTECTION>ALLOW USERS TO EDIT RANGES" but it does not seem to work for me. All of my machines are on the same domain and all are running windows XP. I am able to share the workbook with no problem. Any assi... 1 20.09.2006 03:26:01 I want Excel to randomly select a name from a list -- brightstar... 2 20.09.2006 03:18:23 Dealing with Text in a Function cell I have 2 spreadsheets in one workbook that contain some of the same data. I've used the following function to poplutate the data entered into one spreadsheet into the other with the same data: =IF('Reg Doc Tracking'!H2,'Reg Doc Tracking'!H2,"") It works fine with any dates that are entered but I run into a problem when I have text in the Reg Doc Tracking H2 cell. I need to be able to... 4 20.09.2006 01:24:36 Entering Formulas I want to be able to enter a value into C2, for example, and have a formula that will take that value and multiply it by .02, for example. The result to be reflected in C2. Can I do this?... 3 20.09.2006 01:12:08 Resort Column from one with blanks I used to know how to do this but forgot the formula.... ex: A | B -------- 4 | 4 C | 6 | C 7 | 6 | | 7 Any help would be greatly appreciated.... 2 20.09.2006 01:11:02 How do you attach tabs to make one page or several pages? I'm trying to make one file out of an excel worksheet that has 3 worksheets. I don't want 3 files, I need to make 3 pages. Then I'm going to convert it to Adobd PDF. How do I make the pages. How do I attach them to end of each worksheet?... 4 20.09.2006 01:09:09 No "Sheet" tab exists on Page Layout. Need to print gridlines.??? Help for Excel from MS for printing gridlines is incorrect. It says to click the Sheet tab in Page Layout; however, there is no Sheet tab, only Margins, Paper, Layout are available & I can not locate a box to check to print gridlines on any of those 3 selections. HELP!... 5 20.09.2006 01:04:26 How do I create a macro to add zeros in front of a value? PLEASE SOMEONE HELP ME!!! I have to add zeros to over 61,000 line items in excel. I need to know how to create a macro that will enable me to select a range within the same column and have zeros added to the the numbers in the cell. I would be eternally greatful. Thanking you in advance.... 9 20.09.2006 00:54:23 how do i change a case to proper text in excel 2003 Please help, I need someone to help me change case to proper cases on an excel spreadsheet.... 2 20.09.2006 00:21:01 Result = to 0 says false I am pulling my hair out at this point and need some help. I have a worksheet with many cells and calculations. I have calculations performing on results of a calculation. In then end of all of this I have a If statement that says IF(Y4=0,"Yes","No") In the function argument box it says that Y4 is false and the result inthat cell is 0. So it is telling me that 0 is not equal to 0. ... 6 20.09.2006 00:04:01 External Data Functionality I have this code that takes a worksheet and saves it as a new workbook. Is it possible to save this worksheet so that it has the attributes of being enabled to be a source workbook for the external data functions. I wou ld like this worksheet to save and close. Then, if another users chooses, can open up the new workbook and see the change (refresh external data). In practice, the work... 1 19.09.2006 23:59:02 Entering formulas I have a column that I want to reflect a 2% commission when I enter the sale amount into the cell. How do I accomplish this?... 2 19.09.2006 23:11:57 How do I conditional format by referencing failure/success? How do I conditional format a cell by referencing another workbook's failure/success outcome? Here's what I have: Workbook #1 = a fax list with customer IDs and fax numbers Setup as follows: USER ID USER NAME FAX NUMBER 0125A Mom & Pop's Store 16135847581 Workbook #2 = a report from our autofaxing company stating whether the fax was sen... 3 19.09.2006 22:41:21 how do I edit an embedded spreadsheet? I recently received a "leads list", created in Excel, which consists of one spreadsheet embedded into another. The embedded spreadsheet appears to be very large (over 1000 printed pages) and contains a lot of irrelevant information that I would like to edit out, however, I am unable to select any of that information. Can someone please tell me how to edit an embedded spreadsheet or at le... 7 19.09.2006 22:14:01 adding cells how do I add cells within a cell that is used as a function ... 2 19.09.2006 22:10:20 multiplication Help all I am trying to do is multiply two cells together. Cell one is 50.00 and cell two is 0.50 this should equal $25.00 All that keeps showing is the formula. Help gives me this formula: PRODUCT(E10:F10) All I get is the typing. The formula does not work. Please help me.... 3 19.09.2006 22:07:39 Cell Calculation I am setting up a input sheet for fees. I have two cells side by side: one where a dollar amount will be entered and the other with a drop menu. I need for the dollar amounts to be calculated based on the drop down item chosen. For example, if the dollar amount is a financed fee, I need it to autmoatically calculate in an separate cell called financed fees. I think this may be an IF f... 6 19.09.2006 21:58:02 How to merge monthly workbooks into a quarterly workbook?? I do a monthly 3 sheet profit and loss sheet in excel for my employers company and now he wants me to make a quarterly and yearly sheet combining 3 workbooks (or 12 for the yearly) into one. Is there any way to achieve this by merging workbooks andif so how???? Please help!!! Thanks Erin... 7 19.09.2006 21:56:01 Database Analysis Question Hi, I have the following Column A B C D E F G Row 1 Z Y X W V U 2 22 1A 2B 3C 4B 5A 6Z 3 33 1H 3H 4K 7B 8I 9L 4 44 7Q 7N 5M 3P 4G 3E What I need is if ROW 1 = X and Column A = 33 then the answer is 4K. This is for a spreadsheet that is 200 columns by 25,000 rows so I really appreciate the help. Thanks! ... 4 19.09.2006 21:29:17 COUNTIF by days of week I have three columns of data as shown below, but for the entire year: A B C 08/01/06 Tue 2999.78 08/02/06 Wed 3283.59 08/03/06 Thu 1516.91 08/04/06 Fri 2108.34 08/05/06 Sat 2035.85 08/06/06 Sun 3972.03 08/07/06 Mon 2949.30 I need a formula that can calculate the average daily revenue by the day of week, so for year I would know the ave... 8 19.09.2006 21:25:51 Lookup and Replace I need some help in creating a look up to replace some data in my spreadsheet. I had thought about using Access, but need to keep the cell's in the format that they are in, and so cannot accurately import the data into Access for manipulation. A snapshot of my data is below: A B C D E F M2XX ABC DEF GHI ... 4 19.09.2006 21:15:15 How do I copy and paste a worksheet and maintain all formatting? I have formatted one worksheet to use weekly. Everytime I copy and paste it for a new week, I lose some of the formatting. How can I maintain every change that has been made so I can copy and begin data entry without reformatting?... 3 19.09.2006 21:08:12 837 Pages: <<  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  >>