| Thread | Last Post | Replies |
|
| Need help with INDEX/MATCH formula | 07 Mar 2008 14:44 GMT | 3 |
I have two worksheets where the results are formula driven. The data for the worksheets come from two different sources. The result of worksheet A is the following: FIJOL/AGNIESZKA 91009 50.00
|
| excel | 07 Mar 2008 13:43 GMT | 1 |
|
| Formula for Exam Marksheet | 07 Mar 2008 12:26 GMT | 2 |
Hi to all, If in ANY of these cells (F7,H7,J7,L7,N7,P7,R7,T7,V7,X7,Z7,AB7,AD7,AF7,AH7) contains the letter T,P,W,Wn or TH (any of these), the result in cell AJ7 would be the letter X.
|
| I need Excel Help | 07 Mar 2008 10:42 GMT | 1 |
I have another question about my project that I don't understand, if anyone could help that would be awesome! consultants who work on a project also receive a bonus if the fees exceed estimates, otherwise the consultant received no bonus. Create one formula
|
| #VALUE | 07 Mar 2008 10:10 GMT | 1 |
I have a simple spreadsheet for tracking an account balance. Column X is withdrawals, Y is deposits and Z is balance. An entry in Z25 would be =Z24-X25+Y25 Since line 25 will contain either a withdrawal or a deposit, one of the
|
| Excel Ribbon | 07 Mar 2008 09:46 GMT | 5 |
This might have been asked in the past but I can not find a post about it. My question is why is it when you click a command on the ribbon; for instance: -Page Layout -Then put a check mark in Gridlines and Headings to print it takes a while
|
| Sum coloured cells | 07 Mar 2008 08:00 GMT | 6 |
I have a small spreadsheet, say 52 rows X 7 columns (yes, it's a year) Some cells are colour filled red, some blue etc., but are randomly spread across the cells I want a separate sum for all cells that have a red fill color, for
|
| What is the best way to program the custom cell format | 07 Mar 2008 07:24 GMT | 2 |
I need to have a format of all the cells of selected row to be 8 characters and if the word of the cell is less than 8 characters, then padding with space. For example, if I enter "ABC" in one of the cells
|
| not able to print from line a4 | 07 Mar 2008 06:41 GMT | 2 |
The following code ends in print preview starting line 7 and not line 4. any suggestions please. I changed A7 to A4 in the with statement and still the same problem. Sub Picture22_Click()
|
| #VALUE | 07 Mar 2008 04:57 GMT | 4 |
I have a simple spreadsheet in which three columns are used to keep track of an account balance. Column A is withdrawals, B is deposits, C is balance. A typical entry in C25 would be =C24 - A25 + B25. One of the cells in A or B will be empty in row
|
| IF Function Help | 07 Mar 2008 03:12 GMT | 2 |
I have a project that requires me to calculate bonuses for employees. I am pretty sure that I need to use an IF function. Here is the question: If the project fees do not exceed estimates the manager receives an 100 bonus. Algebraically, this is Bonus=(actual-projected)*bonus rate ...
|
| Sorting in one tabs messes up formulas in another tab | 07 Mar 2008 02:38 GMT | 3 |
I'm not sure if this problem was solved before so sorry if this is a repeat question. Let's say I have one spreadsheet tab that originally has the following: Col A Col B
|
| Extract first names, middle names, last names and JR/SR | 07 Mar 2008 02:21 GMT | 8 |
I have formulas which will extract first, middle and last names but I need one that will append the JR/SR/III onto the middle name. What I have now assumes it is the last name. Thanks for your help.
|
| Insert a blank row between each used row in document | 07 Mar 2008 01:28 GMT | 7 |
I need a macro to insert a blank row after each row in my document; that is, every other row will be an inserted row. For example: I have:
|
| Best approach for conditional formatting? | 07 Mar 2008 01:21 GMT | 4 |
I would like to make numbers within certain ranges show up in different colors. I'm very new to Excel, but have programmed scripts in Access and know what an Access macro is - as well as the Access "conditional formatting" feature. What is the best approach to take in Excel? ...
|