| Thread | Last Post | Replies |
|
| Preventing user entering duplicate values in a cell range | 30 Nov 2005 20:00 GMT | 1 |
I have a series of horizontal cells (7 IN ALL) that we use to track which phases a document status is currently in. A. not started=NS B. in-progress=IP
|
| Calculating percentages | 30 Nov 2005 19:38 GMT | 2 |
I'm preparing a report in which I'm comparing this years sales to last years sales... What formula can I use to calculate this percentage?
|
| using a hyperlink how do I send an updated file without saving it | 30 Nov 2005 19:23 GMT | 1 |
I have a hyperlink in a spreadsheet that others update and e-mail to me. However, the corrected spreadsheet is not showing up as an attachment. How do i make this happen?
|
| email using hyperlink | 30 Nov 2005 19:23 GMT | 1 |
i have a form that my employees update and should be able to e-mail. however, when they click on my hyperlink I end with a blank e-mail. Why is this and how do I get to form to send as an attachment?
|
| If statement help | 30 Nov 2005 19:21 GMT | 2 |
Does anyone have any sugesstions for the following: I have the following formula that looks at the first three digits in cell B18 and enters a various code based on certain situations. =IF(ISNA($B$7),"",IF(AND(LEFT($B$7,3)="122",$B18>=1000000),"G3",IF(AND(LEFT($B$7,3)="629" ...
|
| Conditional formating on if statement | 30 Nov 2005 18:59 GMT | 2 |
Hi, I have 3 workbooks, 1st one I will call 'old', 2nd one 'New' and 3rd 'Comparison'. The 3rd workbook contains the if statement to compare the same cells in the old and new workbook and therefore these cells contain true or false. I would like to build a conditional format ...
|
| how to split data from 1 row into two rows continuously | 30 Nov 2005 18:56 GMT | 3 |
trying to split data from 1 row into two separate rows, then copy and paste the function(s) without skipping rows. i don't know how to word it better, but here is my problem: a b c d e f g h i j k
|
| Clipboard Popup | 30 Nov 2005 18:51 GMT | 1 |
Every time I copy/paste more than one item, the Clipboard viewer pops up. I have tried unchecking the option to "Show Clipboard Automatically". It seems that every time I start Excel, this is getting reset. Can this Clipboard viewer popup be stopped? I have looked thru the ...
|
| Using a 'Select' (Data Validation) List? | 30 Nov 2005 18:43 GMT | 6 |
Howdy! I have a spreadsheet with a few hundred entries in it on sheet 1. One of the columns in the sheet is State, and an adjacent column is County. I am only working with 3 or 4 states, but combined they have a lot of counties! Since the Data Validation list option only holds so
|
| Leaing to the next full number? | 30 Nov 2005 18:34 GMT | 3 |
How do i get a number to leaing to the next full number? Eks: 5,69 = 5 4,31 = 4
|
| Run-Time Error | 30 Nov 2005 18:15 GMT | 2 |
The following macro gives me a "run-time error '13' Type mismatch" pop-up when I delete row. When I click on Debug it is the ".Value=UCase(.Value)" that's highlighted. What is wrong? Connie Private Sub Worksheet_Change(ByVal Target As Range)
|
| Excel should have a bar button to center across selection | 30 Nov 2005 18:13 GMT | 1 |
As a selection of a range of cells, and the copy and paste action are afected when crossing a merged cell, I prefer to center cells across selection, not to merge them; it will be usefull to have a bar button with this command. ----------------
|
| Where is the Data Tools group Help refers to when splitting cells | 30 Nov 2005 18:02 GMT | 2 |
Where is the Data Tools group Help refers to when splitting cells? Here's their link: http://office.microsoft.com/en-ca/assistance/HP012163991033.aspx
|
| 'find' somtimes can't find numbers. I folowd the 'help' instructi. | 30 Nov 2005 17:46 GMT | 2 |
I'm working with excel 2003. I have a problem with the 'find' function. With the very same settings- very often I get no results. To check the function I'm simetimes entering values that are on the sheet, & yet get no results.
|
| HELP! Nesting IF Statements/Dependent Dropdown List | 30 Nov 2005 17:38 GMT | 4 |
I am having difficulty understanding how to formulate multiple nested IF statements in order to produce the precise result based on the conditions. My first stumbling block is knowing where to place the parentheses to establish the precedence of the conditions to be evaluated i.e ...
|