| Thread | Last Post | Replies |
|
| Worksheet does not copy | 16 Mar 2007 00:40 GMT | 9 |
I have tried to move and copy a worksheet but nothing happens using the right click or the edit route. The workbook is not protected. I can insert new worksheets. HELP!
|
| Copy text from cell to cell with one cell changing text | 16 Mar 2007 00:09 GMT | 5 |
I want to copy text from cell Sheet1 B1 to cell Sheet2 C3. Then when text is changed in cell Sheet1 B1 the new text is copied to next cell in Sheet2 columnC (cell C4) and so on.
|
| Using list values as variable in secondary formulae... best way? | 15 Mar 2007 23:50 GMT | 1 |
Been struggling with this for a few hours and not making much progress, hoping someone can help me out. I've got an analysis XLS that has a bunch of interviews and a bunch of analysis pages that look at aggregate responses for the questions
|
| Counting cells with multiple selection | 15 Mar 2007 23:35 GMT | 2 |
How Can I have multiple condition using countif function Can we use the Countif function or any other function if we are working with dates or strings. Ex: to count cells between 2 set of dates or to count cells that match
|
| Count if multiple statements in two columns | 15 Mar 2007 23:32 GMT | 3 |
I need to create a calculation where the range creiteria in my first column is ">=7<=9" and my second column ="30+" before it is counted. I'm not sure how to work both statements into this calculation. ie: countif(q2:q100">=7<=9" and r2:r100 "30+)
|
| Formula Help | 15 Mar 2007 22:31 GMT | 1 |
I want create a formula that if the Min column (C3, F3, I3, and so on...) is greater than 0, then A1 will combine the XX1, XX2, XX3 and so on... can anyone help???? FAC, MIN and MAX are their own column
|
| creating list | 15 Mar 2007 22:17 GMT | 7 |
is there a way to get rid of the blue line that surrounds the cells when you use lists?
|
| how to duplex mulitple sheets simultaneously? | 15 Mar 2007 22:03 GMT | 1 |
I want to select multiple spreadsheets to duplex print at the same time. How do I do this??
|
| text lists - begin typing names | 15 Mar 2007 22:01 GMT | 1 |
I have a list of teams in one column, i would like to begin typing a team name in a separate cell and excel will recognize the name and fill in the rest...similar to how some search engines work. is this possible?
|
| CountIF Function | 15 Mar 2007 21:38 GMT | 3 |
How Can I have multiple condition using countif function. Ex: If I want to count only those cells that have value >300 and <700
|
| How do I stop Excel from progressing a formula in fill down or rig | 15 Mar 2007 21:35 GMT | 2 |
I am trying to use a sumif command and want excel to copy the formula in each cell EXACTALY like it is. Excel keeps "progressing" the formula. I just want the exact formula repeated over and over.
|
| Unwanted spaces | 15 Mar 2007 21:24 GMT | 3 |
I copy data from a different program and paste it into a spreadsheet and some of the cells have unused spaces behind the last character. When I link that data into the cell I want to post it into, it does not center with those 8 or 10 spaces. How do I format my destination cell ...
|
| Sharing info across 2 workbooks | 15 Mar 2007 21:18 GMT | 18 |
I am using Excel 2003 and I have a lot to learn. I have two workbooks. One is a QUOTE WORKBOOK and on is a JOB RECAP. The QUOTE WORKBOOK is used to quote and process jobs. It contains a series of worksheets. Once the information about the specific job is entered it is
|
| How can I make a column "float" as I scroll horizontally? | 15 Mar 2007 20:13 GMT | 4 |
I have a large amount of data that needs to be tracked horizontally across 26 pay periods. I'd like the first column (a list of names) to stick or float as I scroll to the right. Any insight?
|
| Active cell as a reference to open a worksheet | 15 Mar 2007 20:06 GMT | 6 |
Is there a way to use an active cell to jump to another worksheet, I.E, Ive got a sheet with 53 cells with week commecing dates, ive also got 53 sheets named wk1 to wk53, I would a index sheet to use to jump to the required wk? sheet.
|