| Thread | Last Post | Replies |
|
| Selecting Rows | 22 Aug 2005 16:08 GMT | 4 |
I want to select rows 3 to l_LastRow. I can't say Rows("3:l_LastRow"), so what are my alternatives? Thanks! This is what I have: ----------
|
| Convert Text (letter) To Number Excel | 22 Aug 2005 15:49 GMT | 2 |
I really need someone to help me out with this basic function: On microsoft excel, I need a LETTER (ALPHABET) in a cell to be converted to a numerical value automatically. EXAMPLE:
|
| Large function | 22 Aug 2005 15:34 GMT | 4 |
Hi Group I am trying to find the top 10 values in a range. If a value is repeated then it may show up say as the largest and next largest. How do I ignore repeated values.
|
| this may be simple, sumif question | 22 Aug 2005 15:12 GMT | 3 |
i have a column that gets 2 values in it either a number which could be 0, or a blank. i would like to sum another column if the first one is empty(blank). column A column B
|
| Workbook formulas | 22 Aug 2005 15:05 GMT | 1 |
I know this is probably a pretty simple question, but I need to ask it because I can't figure out how to do it myself. I have a workbook that has three worksheets in it. The third worksheet is supposed to take totals from worksheets 1 and 2 and combine them.
|
| Next Row | 22 Aug 2005 14:52 GMT | 2 |
I'm trying to find the code which automatically finds the next available row in excel in order to paste some data from the clipboard. Please could you help?
|
| How can I convert Text into numbers? | 22 Aug 2005 14:04 GMT | 8 |
I have imported data from a survey tool into Excel. Unfortunately, instead of importing the selected fields in a question with a number, it is imported and shown as text (i.e. Question 1: Yes ( ), No (selected) instead of : Yes( ) No (1))
|
| countif criteria only one word of few doesn't work | 22 Aug 2005 13:46 GMT | 3 |
I am trying to use countif where the criteria in some cases will be on word from a cell that has several words in it. I'm getting a tota count of 0 in these instances. Is there a way to set the criteria t work this way or perhaps a different counting function?
|
| Help! Formula between the sheets | 22 Aug 2005 13:31 GMT | 2 |
Hi guys, how can I have formula on one sheet that refers to values on another sheet within the same workbook? Eg sheet one has formula b1/a1- but the values refer to the cells in sheet two, but the answer is in sheet one.
|
| Sum of comma seperated values in cell(Reposting) | 22 Aug 2005 13:17 GMT | 3 |
Can anyone help me in writting a formula to find the sum of comma separated numbers in a cell Thanks in advance
|
| Help with VLookup function | 22 Aug 2005 12:47 GMT | 6 |
I'm struggling with a VLOOKUP function where I'm referencing a particular postal code to a table and the VLOOKUP is returning inconsistent results. The syntax is: =VLOOKUP(C8,AZ1:BB1578,3)
|
| what exactly are relational operators in Excel? All math symbol? | 22 Aug 2005 12:31 GMT | 7 |
I am taking a test this week and one of the questions (which has been supplied by the instructor) is a multiple choice with answers which do not seem to be correct. Are Valid relational operators: + * / + or -, or should they be: "equal to, not equal to, less than, etc. as ...
|
| #REF! help | 22 Aug 2005 11:14 GMT | 5 |
I copy and paste a web page into excel in sheet1 The page I import changes every day and is different in size , I delete all data in sheet 1 and copy and paste the new web page in sheet 1.
|
| Age with mont in decimal | 22 Aug 2005 10:31 GMT | 1 |
Please can someone help me. I need formula to get age and month I use the following, but get (example 53 0 instead of 53.0) =DATEDIF(H22,(L22),"y")&" "&DATEDIF(H22,(L22),"ym")&" "
|
| #N/A! to be blank please. | 22 Aug 2005 10:02 GMT | 1 |
Hello from Steved if no value it is returning a #N/A! please how to I have the cell blank I know it is iserror but not to shore how to go about putingit in the below formula.
|