| Thread | Last Post | Replies |
|
| from a cell which has numbers how to get it spelled | 13 Jul 2006 20:21 GMT | 2 |
please somebuddy help me with a formula from a cell which has 3564 in numbers and in the other I want in words like three thousand five hundered and sixty four
|
| Dependent Lists in Excel | 13 Jul 2006 20:15 GMT | 14 |
I've created a dependent list in Excel using Data validation. The first list is independent and the second list depends on the first list. I'm facing one problem in this. After selecting a element in first list and corresponding element in second list, if I want to change the first ...
|
| calculating a 2-log drop | 13 Jul 2006 19:46 GMT | 2 |
Hey all, quick formula question: For explanatory purposes, Ive got a number in Cell A1 that is a patient's baseline viral load, and in Cell B1 I've got the patients viral load at 12wks of treatment. I am having trouble figuring out how
|
| Use multiple criteria with COUNTIF: between dates and not blank | 13 Jul 2006 19:21 GMT | 7 |
Using Excel 2003 I need to count rows where the date in column A is in a particular month and year and column G is not blank.
|
| Why can't Conditional Formatting do other formating such as number | 13 Jul 2006 19:03 GMT | 3 |
I want to set the number of decimal places for a cell based on a condition in another cell. You cna't do that in conditional formatting. Is there another way? ----------------
|
| Sorting rows | 13 Jul 2006 18:51 GMT | 3 |
I have a spreadsheet that has alternating gray/white row colors. When I sort the spreadsheet by rows, the colors sort as well. Is there a way too sort without the colors in the rows sorting as well. I creates problems with the format of the spreadsheet.
|
| worksheets | 13 Jul 2006 18:36 GMT | 2 |
How do I change the "zoom" on all the excel sheets at one time?
|
| How Do I add/sum the numbers in one cell...((More Info Below)) | 13 Jul 2006 18:20 GMT | 1 |
Hello. What I'm doing exactly is Let's Say A1 I have this: 1,5,8,9,10,12 And Now in A2 I want to put the sum of these numbers... So I want to add the numbers even though they consist of commas.
|
| Average Time Difference | 13 Jul 2006 17:58 GMT | 4 |
I have a deadline time entered as 10:11 in B7. In c7 through s7 I have the actual times, i.e. 10:06. In most instances the deadline was met, but in a few it was not. I'd like to have the average time variance between the deadline and the actual. I'm not very sophisticated in
|
| Macro to capture worksheet names | 13 Jul 2006 17:56 GMT | 2 |
I have a spreadsheet that gets clobbered from time to time by data entry folks. Part of the problem is a macro that can't find a specific worksheet because the name may have been changed. Is there a way, using a macro that can look at each worksheet and capture
|
| macro takes 30+ seconds to do an autofit on only 1 of 3 sheets it is autofitting | 13 Jul 2006 17:48 GMT | 1 |
hey, for some reason this macro is taking 30+ seconds to perform a fon change and autofit on the 2nd sheet in this workbook. sheets 1 and 3 are almost identical (in rows and columns) and those happen in about second or less. i am not sure why the 2nd sheet (ReArranged - No
|
| How do I get ONLY new info from 1 Worksheet to another automatical | 13 Jul 2006 17:45 GMT | 6 |
I am using Excel 2003, Windows XP Pro SP2 I have a Multiple Worksheet file I do not know how to create or use Macros, but I am fairly good at using functions.
|
| cells visable and following. Not freeze | 13 Jul 2006 17:40 GMT | 2 |
Hi. How can I set a group of cells to follow my scrolling? You know the sort of thing. An information box. When I scroll left or right the group of cells would always be in view.
|
| Here's a good one! | 13 Jul 2006 17:28 GMT | 4 |
I am trying to split loan payments between principal and interest amon various sources, however due to rounding the total principal an interest exceeds the total payment. What is the easiest way to adjus either the largest principal or interest field based on which type i
|
| Search column for value and return TRUE or FALSE | 13 Jul 2006 17:07 GMT | 8 |
I function that would search through column of text values (range with 1 column) and return TRUE if column contains value given as criteria or FALSE if there is no such value in given column For example i have range A1:A10 and i want to find out whether this range
|