| Thread | Last Post | Replies |
|
| Excel Query Does not Work | 28 Jan 2007 06:30 GMT | 1 |
I have an Excel Data base defined using the names. The worksheet contains 10 sheets. The name contains four columns. When I do a query I'm not able to retrieve one of the fields. It is numeric. Any suggestions on how to correct this problem?
|
| CountIf with multiple criteria | 28 Jan 2007 03:59 GMT | 2 |
I'm trying to set up some countif statements that will count the number of cells within a given range that contain number within a given range. Ex. One column has a list of random numbers from 0-100. The next
|
| Making Invoice templetes in excel | 28 Jan 2007 03:21 GMT | 2 |
hello, family new to excel 2007; how do i lock the cells so the text will not change, but the empty cell can add text. its for an invoice, would like to set the worksheet up so brokers can type in the field and when they press enter the
|
| adding multiple checkboxes in a single cell | 28 Jan 2007 02:53 GMT | 1 |
I want to add 2 checkboxes in one cell, similar to a yes/no checkbox but name one contract and one permanent so that the person entering the data chooses either or in that cell in order to identify if an employee is a permanent employee or not. Can this be done in excel?
|
| Extracting name out of line | 28 Jan 2007 01:41 GMT | 1 |
I am copying a line off the web with 4 names in it, separated by spaces (From 1 to 6 spaces). I am trying to extract name 3 from the line. Tried split(Var, " ") however Name moves according to the space between the names. Var(2) can be the Name or according to spaces
|
| Date problem | 28 Jan 2007 01:32 GMT | 4 |
I am wanting to work out the time difference between two dates. Lets say 1/1/2000 to 10/4/2003 I want the answer to be displayed in a years months and days format. The answer to the above would be reported back as 3 years 3 months and 9
|
| find first empty cell in range and then copy from another workbook | 27 Jan 2007 23:39 GMT | 1 |
I am looking for a formula function or a vba code where: - In workbook1 find the first cell that is empty between range A7 - A10, - In workbook2, in Range G10- G13: find the word "Day1".
|
| Help: Formula for calculating Baseball League Age? | 27 Jan 2007 22:38 GMT | 4 |
Ok, I have been playing with excel for quite a while now and have been able to calculate a persons age. But, I have been unable to calculate a persons baseball league age. Here is the rule for league age: "whatever age a player is on April 30, will be their age for the current ...
|
| Convert Date | 27 Jan 2007 22:32 GMT | 1 |
How do I convert a year (YYYY) in a cell to MM/DD/YYYY format? Is there a formula that will do this?
|
| How I Wok with Exel | 27 Jan 2007 20:05 GMT | 1 |
Por Favor me puede alludar a usar exel Gracias
|
| Multiple selections in Listbox | 27 Jan 2007 19:59 GMT | 1 |
I have 2 Excel VBA questions: 1) Is it possible to choose multiple items in a List Box and if so, 2) how can I use those selected items in a macro (which variable type should I use?)
|
| how to get the address of the ceected cell | 27 Jan 2007 19:29 GMT | 4 |
How can I get the address of a cell whenever I click on it thanks
|
| Excel in differents lenguages | 27 Jan 2007 19:26 GMT | 2 |
Does anybody know how to use functions in inglis in portuguese excel? Tks
|
| Sumproduct Slow | 27 Jan 2007 19:05 GMT | 4 |
I have 13 columns of data with 30000 rows. Most data is numeric some is 2 words at the most. The computer calculates cells very slowly and sometimes will not save due to insufficient resources. I have 1gig ram.
|
| Logical test | 27 Jan 2007 17:56 GMT | 2 |
I am creating a spreadsheet application on Excel 2000 to record the time (24 hour clock) when checks are made each day of the week by a person’s identification. To accomplish this, a logical test is used in the column (say Column D) for recording the time the person made the ...
|