| Thread | Last Post | Replies |
|
| Wildcard IF formula | 12 Apr 2006 18:22 GMT | 3 |
Help for the needy... please? Am trying to make a wildcard IF formula to work. The sample below doesn't work because IF formula can only match by one word and not a word within a few. I'm looking for a formula to detect the keyword "yellow" in each row in
|
| PHONE NUMBER formatting | 12 Apr 2006 17:44 GMT | 3 |
All I want to do is have my phone numbers appear (555) 555-5555, but for some reason I keep getting all these weird -- in between the numbers. I read that I should put "(999) 999-9999"! as an input mask, but that didn't work. Does anyone
|
| copying a reference | 12 Apr 2006 17:32 GMT | 1 |
I have 13 worksheets titled Jan - Dec and Total. Each of the Jan - Dec worksheets are set up identical but after each month, different data is entered for that month. The Total worksheet has 12 columns titled Jan - Dec. Total!A1 = Jan!$A$1.
|
| Download An Open Letter From Al-RASHEDEEN Army To The American President | 12 Apr 2006 17:31 GMT | 1 |
Download An Open Letter From Al-RASHEDEEN Army To The American President click on one from the links below for listening http://rapidshare.de/files/16495134/bush64.rmvb.html http://www.uploading.com/?get=216MX6C6
|
| Address for Linked Files in Formula | 12 Apr 2006 17:19 GMT | 1 |
I don't know if this is an excel issue or a network issue. With many of our excel files that have links to other excel files across a network drive, formulas within cells will point to the file location with the server name and not the drive letter.
|
| what's the formula for finding 401(k)? | 12 Apr 2006 17:12 GMT | 1 |
How do you find 401(k) because I have a question asking, well saying, insert a formula to calculate the 401 (k) contributions for each employee. The formula should determine if the years of employed (4.17) is > or = to 1, then the contribution is equal to the contribution ...
|
| Convert Excel 4 formula to Excel 2003 format | 12 Apr 2006 17:07 GMT | 3 |
Got this formula defined as a name (Cell has formula): =GET.CELL(48;INDIRECT("rc";FALSE)) Used it when I had Excel97 Now I have Excel 2003 and get an annoying message that I have an Excel 4 macro
|
| When I open a workbook, how can I choose which worksheet opens? | 12 Apr 2006 16:59 GMT | 1 |
I want to be be able to set which worksheet opens when I open a specific workbook.
|
| how to freez more five columns without splitting the panes? | 12 Apr 2006 16:54 GMT | 1 |
please help, i can find a way to freez the columns without splitting both rows and columns (panes). thank you
|
| Formula doesn't update when rows are inserted | 12 Apr 2006 16:53 GMT | 2 |
I have a formula that is simply adding cells E8:E184. When I insert rows (begining with E185) and populate those rows with data, the formula doesn't pick these up. In all of my other spreadsheets, the formula automatically updates with the inserted rows, but this one doesn't ...
|
| Linking sheets into one major sheet? | 12 Apr 2006 16:47 GMT | 3 |
I have a large workbook, split into sheets, with very complex formulas in it. I want one sheet at the end of this workbook to reflect all the data from the other sheets, if you know what I mean - so it is ALL the data from the different sheets, in one "all info" sheet. I also ...
|
| get text from another worksheet | 12 Apr 2006 16:27 GMT | 1 |
I am trying to get text data from one worksheet to copy to another worksheet. For example, in column A in wkst1, I have a list of several customer numbers. In column A in wksht 2, I have every customer number and their respective names are in column B. I would like to have a ...
|
| PIVOT TABLE | 12 Apr 2006 16:22 GMT | 1 |
I want to disable refresh options while working in PIVOt table since it is disturing my own format while refreshing or adding my data... pl. advise...
|
| Ranking within in ranges | 12 Apr 2006 16:22 GMT | 2 |
I need a formula that will allow me to rank one column of numbers based on a value in another column. e.g. If I have values in column A and countries in column B. I want to rank the values by country in other words each country will have a #1 etc. also the number of values by ...
|
| Formula to add two cells when one or both cells are text | 12 Apr 2006 16:19 GMT | 2 |
I created a multi-page workbook to determine the sales bonus earned by my employees. The problem is that some of them forfeit their bonus if they don't meet the minimum standards for quality, adherence, retention, etc. Also, if someone has not made a sale or attempted
|