| Thread | Last Post | Replies |
|
| COUNTIF criteria | 24 Sep 2006 20:11 GMT | 9 |
I have the following data: 70 80 71
|
| Totaling pre-defined groups? | 24 Sep 2006 20:00 GMT | 5 |
I am not an excel wiz and I have a problem that is hard for me to solve. I would like to total the # of units for a defined height range. For example: how many units are within the height range of 38-44? or 46-51? I would like to have a simple macro that references cell addresses ...
|
| Sorting | 24 Sep 2006 19:58 GMT | 7 |
I have one column with data but some rows are blank. Is is possible to set up function like "advanced sort" where the data from the column that isnt blank is copied to another column then sorted, but so that if any items are altered in the first column the second column ...
|
| Excel 200 crashes | 24 Sep 2006 19:49 GMT | 1 |
I can open excel spreadsheets no problem. As soon as I try to change the font, or the font size, it crashes. Anyone have any ideas? Thanks
|
| Chart or macro problem | 24 Sep 2006 18:55 GMT | 1 |
problem: Have around 300 student records want to produce a chart for each one, the chart contains 4 pieces of data for each student and is unique to each student, I want to produce a seperate excel template for each student e.g. i will end up with 300 seperate excel files prefably
|
| Exam Marksheet - Grading | 24 Sep 2006 18:33 GMT | 1 |
Please help me with a formula for my marksheet. The exam grading is A, B, C, D and E. E is a failure To pass the overall exam, a student must :- Must NOT FAIL in any 4 subjects from columns E7, G7, I7 and K7
|
| Help with conditional formatting | 24 Sep 2006 17:25 GMT | 2 |
How would you write this formula to show in red? If F1 = 5 OR O1 = 5000 then conditional format these cells in red. B3,B7,B8,B13,B14,B17,B19,B20,B21,B22,B23,B24,B28,B30 Thanks in advance!!
|
| How to display month only for date format? | 24 Sep 2006 14:59 GMT | 2 |
Does anyone know how to display the month only for date format? such as 26 Sep, 2006, it displays Sep only. Thank you for any suggestion Eric
|
| self-sizing adv.filter criteria range | 24 Sep 2006 13:30 GMT | 3 |
I'd like to have an advanced filter which does not need to be told, manually, how high the criteria range needs to be for a filter. In other words, I want a user to be able to enter either one line of data, or two lines, or maybe more. If I put an adv.filt on a range for three ...
|
| Graphing problem. Please help. | 24 Sep 2006 11:54 GMT | 1 |
I have a graph with columns and lines on 2 axes. I'm using the format "Line-Column on 2 axes" but i want specific data sets presented on lines and others on columns. Can anyone tell me how you select whether a data source appears as a
|
| Repeated shading of rows?? | 24 Sep 2006 10:28 GMT | 8 |
I want to create simple planner/calendar: (a) Dates on the left (b) One line for each day. (c) The rest of the line going across the page for my text.
|
| Automated printing | 24 Sep 2006 09:27 GMT | 2 |
I have workbook with ten tabs, I would like to link check boxes on the first page to printing. Is it possible to set a macro linked to a button to look at the check boxes, then only print tabs for which the check boxes relate to.
|
| Editing an excel spreadsheet with the new data in colored text? | 24 Sep 2006 07:52 GMT | 1 |
I would like to know how to edit data in a excel spreadsheet and have the new data go in as colored text the same way that editing is documented on MS Word. I have a very big spreadseet to edit and I don't want to have to bold the
|
| duplicates with a twist | 24 Sep 2006 07:09 GMT | 3 |
I have two lists of e-mail addresses - I want to compare them (I've got them on the same spreadsheet right now) if column "a" has an e-mail address that is in column" b" I want to delete column "a's" cell. Is this possible? Thanks
|
| Very confused.... | 24 Sep 2006 06:44 GMT | 1 |
Can anyone help me with this? Every time I start Microsoft Excel on my PC, a popup box starts saying "Starting Windows Installer". Then a short time after, another popus box displays saying "Installing Microsoft Frontpage".
|