| Thread | Last Post | Replies |
|
| FIND DIFFERENCE BETWEEN >50 AND <60 | 29 Dec 2005 01:09 GMT | 9 |
hi... Sir, For Eg: i have 1000 students...i entered marks to all the students now i need to fine the total students who have score >50 and <60 in each subject..
|
| How do I compare 2 text columns & show differences in 3rd? | 29 Dec 2005 00:42 GMT | 2 |
In Excel XP I'm trying to compare two columns and extract the differences in the 3rd column. For example, Column 1 Column 2 Column 3 ACD ACDI I
|
| SUMIF exluding text | 29 Dec 2005 00:34 GMT | 10 |
Hello I am trying to sum data in a column based on the absence of a character in a related column. That is to say I need to be able to exclude rows that contain an "m" (there may be multiple characters in the criteria cell)
|
| Simple, but not for me...help | 29 Dec 2005 00:32 GMT | 9 |
Trying to set up a simple spreadsheet. Columns A, B, C are client information Column D is Invoice (current one in dollars) Column E is to be total to date, for all the invoices in Column D, adding column D to E each time for a running total. I cannot get this to work.
|
| Multiple Sums Depending on a description. | 28 Dec 2005 23:56 GMT | 9 |
I really don't know how easy or difficult it might be, but here it is: I have something like this (example) : --------------------------------------
| A | B | C | D | |
| I want to change the selected print area but it will not allow me | 28 Dec 2005 23:41 GMT | 1 |
was created by someone else. I can edit like add numbers and information. But it will not allow me to edit the print area, I get only the WHite plus sign(like) as a cursor not the usual cursor to drag and change the print area.
|
| Macro VBA code to name Save-As file | 28 Dec 2005 23:24 GMT | 7 |
The following code works to name a Save_As file (but I want to add data from two cells to the name of the file): ActiveWorkbook.SaveAs Filename:= _ "C:\Filename.xls" _
|
| Excel | 28 Dec 2005 22:39 GMT | 1 |
Is there anything that can be done for a workbook that stops printing the font size chosen? I have a document, all text, that I have used numerous times and now it will not print in 12 or 10 font but shrinks during printing to say an 8 or less. I don't know what I did to the ...
|
| Combo Box Properties | 28 Dec 2005 22:38 GMT | 1 |
When adding a combo box for example, to edit the data source you need to go to properties. Somehow I've manged to change the format which I see the properties appear in. Does anyone know where I might be able to change this back? I think I might have put it into Lotus 123 editor ...
|
| automatic underlining and blue color of email addesses | 28 Dec 2005 22:32 GMT | 1 |
How do I remove automatic coloring of blue for email address and underlining of email addresses in a cell. Also, how do I stop automatic signing on to the internet address when I double click in a cell to revise an email address.
|
| Week/month/year rollovers with PivotTable | 28 Dec 2005 21:25 GMT | 5 |
I have a pivot table that summarizes production data on a monthly and weekly basis. I have generated another table that uses the getpivotdata and displays data for current month-to-date, previous month, week-to-date, previous week, and each individual day of the current week. It ...
|
| excel function reduce and increase numbers | 28 Dec 2005 21:12 GMT | 1 |
I need to find out a formula that increases one number when the other decreases, but does not decrease the number when the other increases. example cell A1=30 B1=40
|
| Concatenate or "&" problem | 28 Dec 2005 21:06 GMT | 6 |
I have tried to concatenate or use the "&" in my database with no luck so far. I get either the #VALUE! or #NAME? result. I have addresses that are separated into columns by number, direction, street, and suite. I want to combine the numbers and text onto one line, in one column. ...
|
| is it possible ot use two or more columns as criteria in VLOOKUP? | 28 Dec 2005 20:35 GMT | 3 |
I need to be able to use two colums (State (B2:C####), County(C2:C####)) to match against corresponding columns 2 and 3 in a VLOOKUP (named FIPS_LOOKUP) table and return data stored in Column 4 to WORKSHEET1!A2. The idea is that a user will populate WORKSHEET1!Col B and C and ...
|
| How to delete rows using formulas | 28 Dec 2005 20:28 GMT | 1 |
have a spreadsheet of employees' names, #'s, etc. I need to delete rows and add new names, etc. The formulas says =+SUM(A73+1) for example. I can't just highlight the row and delete because it gives me an error #REF!+1. Please help.
|