| Thread | Last Post | Replies |
|
| IF text statements | 01 Nov 2005 00:44 GMT | 6 |
Please help! I have a Pulldown menu in H8 with these choices: "Click Here to Rate", "Requirements not met", "Requirements Met" I need a formula or function statement that for this:
|
| Excel worksheets | 01 Nov 2005 00:01 GMT | 2 |
I would like to know how big a worksheet is please
|
| 12 digit code sorting | 31 Oct 2005 23:21 GMT | 5 |
I have a list of 90,000 12 digit records. I need to count the number of time the fourth and fifth digit are 1, 8 (or 18) and, if possible, filter my spreadsheet to hide to rows not meeting this criteria. Mark
|
| Sum YTD Budget | 31 Oct 2005 22:16 GMT | 4 |
I have a worksheet where columns alternate between budgeted and actual income by month (e.g. Col A = January Budget, Col B = January Actual, Col C = Feb Budget...). I need to add a year to date sum, for both budget and actual, which will
|
| Radio Buttons | 31 Oct 2005 22:08 GMT | 6 |
I am using radio buttons (from the control toolbox) for a survey. How do I hide the text "true" and "false" from the properties of the radio button so they do not show up when I print the survey? Bethie at CLG
|
| Function or VBA Help Needed | 31 Oct 2005 22:08 GMT | 4 |
I am trying to do some automation of cells and have an IF Function started. As I continue to build this automation, I am wondering if a VBA solution is better? Any help/suggestions would be appreciated. Current function in all ColB cells starting at row B2 (B1 is empty on
|
| Can I apply Cond. Formatting to a Formula result? | 31 Oct 2005 21:31 GMT | 2 |
Let's say $M3 contains a formula J3/I3 which returns a percentage. I want the row to color if the resulting percentage is over 100%.
 Signature Thank you,
|
| Sum box at bottom toolbar of Excel | 31 Oct 2005 20:59 GMT | 4 |
I used to have a box in the bottom toolbar of my Excel spreadsheets that automatically summed any cells selected on the worksheet. How do I turn that feature on/off?
|
| Text to columns delimited by carriage return | 31 Oct 2005 20:35 GMT | 2 |
I have a column where each cell has values that are separated by a carriage return, and I want to do a Text to Column action delimited by the carriage returns. What is the best way to do this?
|
| DIAS.LAB function poblem | 31 Oct 2005 19:23 GMT | 1 |
I have to calculate the days between two date. But between monday to saturday. The DIAS.LAB function calculate the total days between monday and friday and that is my problem, I have to include saturday. I really want to know is there another function or how can resolve this
|
| GO TO | 31 Oct 2005 19:16 GMT | 2 |
Is it possible to create a Macro which when activated will move the active cell to the equivalent cell in the same row in a different columns. E.g. If the user is in cell A25 if the macro is run the user will be moved to cell AA25
|
| Address and Vlookup | 31 Oct 2005 19:06 GMT | 5 |
I have a workbook which contains depreciation schedules for various assets. I need to create a summary schedule that looksup the monthly depreciation expense for each asset. Each individual asset's worksheet is layed out identically, with the
|
| Begins with as criteria in function | 31 Oct 2005 18:33 GMT | 8 |
All, I'm trying to do a sumif. For the criteria I want to sum anything that begins with a value in cell A7. So my formula looks like =sumif('Worksheet2,!$I$3:$I$586,A7*,'Worksheet2,!J7:J590)
|
| Monthly Totals | 31 Oct 2005 18:22 GMT | 2 |
I have the following formula on my worksheet =SUMPRODUCT(--(Closed!$B$1:$B$5000="Maxwell R"),--(MONTH(Closed!$W$1:$W$5000)=10)). It works great for cells that have a date in them, but some of the cells are blank. This is causing a #VALUE
|
| I Need a formula to evaluate a cell with + or - values | 31 Oct 2005 15:41 GMT | 6 |
The formula in Cell A1 evaluates the values in B1, C1, and D1. B1 can be blank or have numerical values either positive or negative. C1 always has numerical values but can be positive or negative. D1 is either blank or has a text value of "Final". The value of A1 changes ...
|