| Thread | Last Post | Replies |
|
| Countif | 19 Aug 2007 09:20 GMT | 3 |
I'm doing a spreadsheet for exam results statistics at the school where I work. In a column I'm using =COUNTIF(E23:AE23,"A") for the rows of each pupil where the columns are the subjects.
|
| search a data in excel document | 19 Aug 2007 00:28 GMT | 2 |
Need help to search excel document. For example I have a excel document with my Contacts - name, phone, email and address. I receive a call in my cell and couldn't take it and goes to miscall. That number is not already saved in my cell. I need to know who is this, just in case, ...
|
| Comments-Format all Comments-Prior to making | 19 Aug 2007 00:24 GMT | 2 |
I know the answer will be NO. But, some way to format ALL the comments so that they will be a selected font size? And, stay that way for all future comments.
|
| NETWORKDAYS Question | 19 Aug 2007 00:16 GMT | 2 |
I can find the work days between two dates using =NETWORKDAYS(A1,B1) but how do I subtract a number of work days from a given date? (If I know when the project must finish and the number of days it will take, When should I start?)
|
| conditional format | 19 Aug 2007 00:15 GMT | 3 |
I want cell A1 to change to a green font if cell B1>0 and B2<=0 and B3="nw". All three conditions must be true before A1 turns to a green font. What would the conditional formula be? Regards,
|
| Is there a RATE function for single sum? | 18 Aug 2007 23:40 GMT | 6 |
Is there a built in function for calculating the interest rate for a single sum? IOW, is there a function to calculate i in PV =FV/(1+i)^n ? I can do the math to solve for i but I want to know if there is a function
|
| Excel 2007 and QIF files | 18 Aug 2007 20:03 GMT | 1 |
Is there a way to convert QIF files to Excel??? My bank only lets me download QIF files???? Thanks Bruce B
|
| Using Option Buttons | 18 Aug 2007 18:47 GMT | 2 |
I know that this is a dumb question, but after adding three option buttons on a worksheet and grouping them, I cannot exit the edit mode. Whenever I select a option button, I get the rectangle with the four circles to resize it. If I select the other two option buttons,
|
| Hard Formula Question | 18 Aug 2007 17:05 GMT | 6 |
This is a tough one for me. I'm going to use the actual cell numbers in my spreadsheet for the explanation. In cell C2 I have a name (Tom) In a column running from A24 through A108 I have many different names.
|
| print sheet like column breaks in Word. | 18 Aug 2007 16:28 GMT | 1 |
how to print sheet like column breaks in Word? the sheet has 2 columns and I print 4 or more columns in the paper. other than cut and paste the cell data, are there ways? I use office 2007.
|
| Isolating part of a chart | 18 Aug 2007 15:58 GMT | 2 |
I am new to Excel 2007 using Xp Home. I am plotting my blood tests: HbA1c,LDL,HDL and triglycerides. The tests were taken in 2006 and 2007. The data for HbA1c is: 5.8 and 7.2.
|
| SumProduct with date and time | 18 Aug 2007 15:40 GMT | 4 |
I have finally found that with my formulas the calulations are based on the time. Can someone help me find the best way to correct this without using macros to strip the time out of the data. Bob 09/08/2007 01:05 13/08/2007 00:00 Bob
|
| Need to know how to write a formula | 18 Aug 2007 14:22 GMT | 5 |
I have 129 kids at my church and they have been charged with doing certain things to earn points. I am making a spreadsheet to record their accomplishments, like, if they study their lesson they get 10 points, if they memorize a verse, they get 15 points, if they participate in ...
|
| Help printing from Excel | 18 Aug 2007 13:10 GMT | 4 |
I have payroll data - 1 row per month on worksheet 1. At the moment I copy and paste individual cells into sheet 2 (laid out to look like a payslip) and then print it. This means I either need loads of worksheets or can't save the data from the previous month. Is there a ...
|
| How To Avoid Child Windows? | 18 Aug 2007 05:27 GMT | 2 |
Seems like the default behavior of Excel is to open up a new child window for each .XLS I double click on. Is there a way to have it open up a separate, independent Excel window instead?
|