| Thread | Last Post | Replies |
|
| SUMIF where the IF is a variable date from data in a column HOW? | 10 Sep 2009 16:30 GMT | 3 |
Aby SUPER USERS out there? I got a large no of data that are sorted by date, I want to make a formula that can count the occurencies of the numbers 1, 2 3 etc. in column C and show the result in column D, E F etc.
|
| increase cell by 1 | 10 Sep 2009 16:25 GMT | 3 |
Can I create a cell (c3) on a sheet called "results" that increases by +1 each time a particular answer is selected on a quiz? I already have a macro that gives feedback on why a particular answer is correct or incorrect. I would like to have a register that would record how
|
| Running a macro from another workbook | 10 Sep 2009 14:21 GMT | 2 |
I have a project where 5 workbooks are open. When I attempt to run a macro from book2 the macro from book1 runs instead. They do have the same name "Unprotect_Sheets" but the sheet names are not the same.
|
| How do I post a question that Needs to show an equation that won't | 10 Sep 2009 09:42 GMT | 19 |
Dear Excel How do I post a question that needs to show an equation that won't be visually coherent when viewed by this text composer/viewer. Can I send a .jpg that shows the equation to someone ?
|
| Excel Formular | 10 Sep 2009 04:46 GMT | 2 |
Please how do i enter this formular in excel if 0.2 < x > 0.8.
|
| nested "if" formula problem. | 10 Sep 2009 03:54 GMT | 5 |
Hi, group! I can't get a nested if formula to do what I want & I could use some assistance if possible. I've got numbers in 3 columns, E, F, G. I want to put a formula in
|
| Way to have a formula that combines the text of two different cell | 10 Sep 2009 02:59 GMT | 9 |
Any way to have a formula that combines the text of two different cells into a third cell? For example: A1= Hello
|
| How can I select an item in a drop down ? | 10 Sep 2009 00:03 GMT | 1 |
I have a long list in my drop down sorted in alpha. How can I select a letter that will bring me to the list starting with that letter?
|
| Macro takes forever - didn't used to | 09 Sep 2009 23:35 GMT | 5 |
I'm running a macro to rearrange some tables and add alternate row colors. In the past this macro only took about 15 seconds to run and now it takes several minutes. I can't recall installing any new apps besides windows updates in a long time.
|
| Numbers Chart | 09 Sep 2009 23:05 GMT | 7 |
I need a 10x10 chart of numbers 1-100 with the numbers vertical. I'm sure there is a quickie way to do it. thanks, CB
|
| If WB not there; give message: What am I doing wrong? | 09 Sep 2009 22:04 GMT | 3 |
Sub DEC_NY_AutoShape22_Click() ' ' AutoShape21_Click Macro ' Macro recorded 8/31/2009 by Rick Green
|
| Protection of cells in a worksheet | 09 Sep 2009 20:56 GMT | 2 |
How do I protect some cells but not others in a worksheet? I want to be able to protect those cells that I have entered information into and do not want changed but...at the same time, there are other cells on the same worksheet/workbook that I want to add/enter information into ...
|
| Find the rightmost value | 09 Sep 2009 18:56 GMT | 5 |
I have some values in A1:H1. Some cells can be empty or 0. I like a formula, that will return the rightmost number, larger than zero. This can be in any cell in the row. A1 B1 C1 D1 E1 F1 G1 H1
|
| Copy sheet to a new book, but remove any macros associated with that sheet | 09 Sep 2009 18:44 GMT | 1 |
I need help writing code that copies a sheet into a new book, but I need to remove or disable the macro I have associated to the sheet. Here is the code I have when the sheet from the master workbook is opened:
|
| Circular reference, Indirect, and Sum | 09 Sep 2009 17:15 GMT | 3 |
Excel complains of an error every time I open up a worksheet, saying that there is a circular reference. My worksheet contains numbers in L18, L19, L20, L21. The formula in L22 is: =SUM(INDIRECT("l18:L20")) . This outputs and adds the cells
|