| Thread | Last Post | Replies |
|
| New to Excel with Question | 26 Jun 2005 05:01 GMT | 1 |
I am new to Excel and thought this a good opportunity to learn something about Excel. The Project I am working on requires figuring out the Vacation hours earned after being employed X number of years. If present year minus year of employment is greater than (or less than) X,
|
| formula help | 26 Jun 2005 01:35 GMT | 3 |
I need an IF formula for cells c5 through h5, If a number is entered as a negative then an error message should appear in cell b10 that says "Error" Thank You
|
| Concatenation | 26 Jun 2005 00:53 GMT | 3 |
Is it possible to concatenate multiple cells that are in consecutive cols and in the same row without having to input each cell reference:- in other words is there something similar to =SUM but for text. =CONCATENATE (A1: W1) does not work but what does?
|
| Setting up pages in a workbook | 26 Jun 2005 00:15 GMT | 4 |
I have just created hundreds of workbook pages with different data. What I would like to know is how do I set up every page to be in the same format without having to do each one separately? :eek: Thanks ahead of time.
|
| Extract Unique Values, Then Extract Again to Remove Suffixes | 25 Jun 2005 22:38 GMT | 23 |
I have a list of builders where I want to extract all the unique values. Using =IF(COUNTIF($A$1:A1,A1)=1,A!,"") works fine to get the first set of unique values, but I need to extract it a bit further. The builder names may be Ryan 50, Ryan 60 or just Ryan. I need to combine ...
|
| Transition Navigation Keys in Pivot Tables | 25 Jun 2005 12:40 GMT | 1 |
In Excel 2003, I have set Tools > Options > Transition > Transition Navigation Keys to "on". The shortcut keys for highlighting a contiguous range of data work fine EXCEPT for when I am in the pivot table wizard.
|
| excel to merge for labels in windows | 25 Jun 2005 12:01 GMT | 3 |
I have been given a Excel spreadsheet and need to print labels with the information and i am new to excel. I am trying to get the ionfo to word,but the information doesn't not transfer over.
|
| the answer dont display just the formula i input help | 25 Jun 2005 10:26 GMT | 2 |
when i type the formula in the cell j5 =k3-100 it does not display changes when i try to input a value in k3 the formula is still displayed at j5 and does not show the answer there.
|
| Excel 2003 on Windows ME?? | 25 Jun 2005 02:10 GMT | 2 |
Will Excel 2003 run on Windows ME?
 Signature Sarah
|
| How to solve? | 25 Jun 2005 00:43 GMT | 2 |
I want to calculate col A *0.82 and then want to still set the result to col A,I want to how to do.thank you.
|
| Problems with programs, help files, excel, on partitioned hard drive | 25 Jun 2005 00:24 GMT | 7 |
Good Morning, Not sure where to post or where to start with this one. I have a hard drive with several partitions. Windows 2000 and IE are on the C: partition and everything else is in it's own partition. So
|
| search form in sheet | 24 Jun 2005 23:10 GMT | 3 |
I have long column with names and it very difficult to find them. I lose a lot of time to use the form from “menu / edit “. I want to create search form or something ells in order to find text quickly in column, but I don’t now.
|
| Data validation dropdown list | 24 Jun 2005 23:05 GMT | 2 |
The Data validation dropdown list appears to need the list of validation data same work sheet. I would like to have my validation data on a separate sheet. Can this be done?
|
| V92 modem | 24 Jun 2005 22:52 GMT | 1 |
I would like to upgrade my modem to a V92 speed. I'm not really sure that I know what I'm doing. Are there any unique problems that I need to know about? Dell 4550
|
| mortgage | 24 Jun 2005 22:41 GMT | 2 |
I am new to excel. I have never used it before in my life. I need help creating an amortorization schedule. I guess that would consist of setting up the cells so that one can enter the PV, YEARS, AND INTEREST RATE. and the results shoudl show the payments seperated as principle ...
|