| Thread | Last Post | Replies |
|
| array formulas | 17 Mar 2006 17:41 GMT | 2 |
I'm a liitle confused about the difference between "regular" formulas and array formulas. For example, I'm using "SUMPRODUCT" with 2 criteria to sum values. I am getting the correct sum, even though I don't have the array brackets in
|
| Is this possible? | 17 Mar 2006 17:38 GMT | 11 |
I have created a database of names & addresses from a software progra called "CLIP" into excel, which in turn will become a label mail merg in MS word consisting of 900-1000 customers (for a mass mailing). The problem is, the names were created last, first and I would like t
|
| How do I specify subscript within functions in Excel? | 17 Mar 2006 17:37 GMT | 1 |
I would like to display numbers as subscript within a combination text-number string (but solely the numbers). This is generally important for aesthetic appeal and legibility. Example: I'd like to automatically generate the formulas for hydrocarbons
|
| Q about exporting macros | 17 Mar 2006 17:25 GMT | 2 |
I have forgotten the best way to export a macro from one computer, then import it to another. Depending on where I am, either under tools > macro > macros > edit, or under tools > visual basic editor, I see two different files types, .cls
|
| How do I transfer formulas but not the information? | 17 Mar 2006 17:05 GMT | 1 |
I have a spreadsheet that consists of 8 worksheets, each page is formulated to transfer accumulated data to another sheet. It is for statistics for a club. My questions is how do I transfer the worksheets and the formulas without transfering the data? I have tried to save as a ...
|
| What makes diferrent? with or without '+' | 17 Mar 2006 16:55 GMT | 2 |
Hi, Pls let me know what are the diferrent with or without the simbol '+' in this formula: =+'sheet1!'A1
|
| formula help to change row colour automatically by some conditions | 17 Mar 2006 16:51 GMT | 6 |
Hi Good People, I am working in excel worksheet for a payment collection activity and in culumn Ato Column Z i have detail of customer and in column AB i have amount of payment received and in column AA i made a condition by using if formula
|
| Can I import many .txt files in a single worksheet automatically? | 17 Mar 2006 16:43 GMT | 1 |
I have 1000 text files that I want to import in a single Excel worksheet. I know I can do it manually (open each file individually, select the coma in the text import wizard and click finish, then copy and paste in the single worksheet), but is there a way to do it automatically ...
|
| Find avg & Max for grades | 17 Mar 2006 16:31 GMT | 7 |
I have range (A2:A35) for subject grades (A,B,C,D,E) What I want to know, it is possible to find avg grade and max grade score by student? pls guide me.
|
| how to reset form | 17 Mar 2006 15:54 GMT | 1 |
How do you reset a form after macros have run? I have a macro that deletes all lines that have a 0 in column C after data has been pulled in from other sheets. I need to add a button that will restore the form to it's original state.
|
| how to convert amount in figuers t oamount in words | 17 Mar 2006 15:39 GMT | 1 |
if i want to convert amount in figueres 100 to amount in words as hundress how can i do is there any function or way to do it
|
| If Function | 17 Mar 2006 15:20 GMT | 1 |
What I want to do is get excel to compare a reference number to a lis of of reference numbers and if it is in the list more than once out pu -1. I have been working on this for ages but cannot seem to find a way o
|
| Average of Last 10 | 17 Mar 2006 15:17 GMT | 16 |
What I am trying to do is track a 10 week rolling average, where scores are entered weekly in row A6 thru W6. The formula needs to count back starting with W6 until it counts 10 scores then average them. Some cells may be blank.
|
| Convert from number to text | 17 Mar 2006 14:49 GMT | 2 |
sir in excel how we convert number to text in english version???
|
| Combining data from 2 worksheets | 17 Mar 2006 14:21 GMT | 1 |
I have 2 worksheets with the following data: Worksheet 1---All Project (A1-A21)---Number of sites (B1-B21) Worksheet 2---Customer Name (A1-A39) then columns B-H have the All Project value if applicable.
|