| Thread | Last Post | Replies |
|
| Formula for finding data from 2 worksheets | 04 Sep 2007 22:20 GMT | 9 |
Hi; I am trying to find a formula that compares the data from one worksheet to another. If the data matches I want data from another column on the second page. Example
|
| Macros I think | 04 Sep 2007 22:08 GMT | 1 |
I am trying to put together a function to help automate a really long process. I need to copy a number from one cell of one workbook to multiple worksheets of another workbook. The problem is that the cell I need to paste to is different in each worksheet. In the first ...
|
| Test cell interior color by worksheet function? | 04 Sep 2007 21:40 GMT | 7 |
I'm trying to conditionally test a cell interior color, by worksheet function (not VBA). I intend to use the responses to permit varied numerical consequences... I've seen no Excel Help addressal on this, just on text (contents) coloration.
|
| i need help with formula | 04 Sep 2007 21:25 GMT | 4 |
I am trying to create a formula and need help. What I am trying to do is create a formula for my fantasy football draft. What I want is for the first box to be like a dropbox type thing where I can put QB, RB, etc.. from there if I pick QB then I want to be able to pick from a ...
|
| Paste changing cell contents to consecutive cells in a column | 04 Sep 2007 21:21 GMT | 3 |
I would like for the contents of a cell (ie: A21) to post to a cell in another column (ie: D1). However, when the contents of A21 change I would like for the new figure to post to the next available cell in column D (D2). I want that process to continue in consecutive cells as ...
|
| how to prevent a worksheet from being recalculated? | 04 Sep 2007 20:50 GMT | 1 |
I have a complex nonlinear regression worksheet/workbook in which the results are written by a button-activated macro into another (summary) worksheet. It takes a while for the worksheet to be calculated and the results written, but it's even worse than the worksheet ...
|
| Conditional Formatting Help | 04 Sep 2007 20:45 GMT | 5 |
I want for a cell to change color if one cell E15 has an R in it and if cell G15 is more than 8.5 hours. Any help would be appreciated.
|
| Conditional formatting and time | 04 Sep 2007 19:46 GMT | 1 |
I would like to change the color of a cell if there is a "Y" in one cell and an "R" in another cell and if it is past 7:00pm. Any help on a formula would be appreciated!
|
| Pivot table and customer analysis | 04 Sep 2007 19:38 GMT | 1 |
I have a dataset of customer names, the months when the made a purchase and the amount of money the spent. It is in this format Customer Name Month when purchase was made Qty. of purchase Customer A Jan
|
| VLOOK up returning #N/A even though value exists in lookup array | 04 Sep 2007 18:56 GMT | 1 |
I've had this problem before and it was fixed when I'd sort the lookup array in ascending order. Did that, still no good. I've also made sure both fields were text. Still no good. But when I copy the value being looked up, and do a find for it in the
|
| Phone with/without area code format | 04 Sep 2007 18:15 GMT | 2 |
Phone field is text without input mask. If we type 7 digits, I want it to display as ( ) xxx-xxxx If we type 10 digits, I want it to display as (xxx) xxx-xxxx
|
| Excel 2K and parsing data | 04 Sep 2007 17:42 GMT | 2 |
I have a range of numbers (1-20) in multiple columns, but only 6 of them are used in a particular column. As an example col1 would have 1,2,5,8,9,15; col2 would have 6,7,8,10,15,20; etc. Since the numbers are entered in their corresponding cell location (ie 1=B1, 2=B2, 5=B5, ...
|
| using a formula for a column or range | 04 Sep 2007 17:42 GMT | 2 |
I am trying to do a spreadsheet with this funtion =A1*D1 and not type this in 900 times ex: =A1*D1
|
| Linking Excell Spread sheets | 04 Sep 2007 17:34 GMT | 2 |
We are trying to link data from workbook to workbook. We are doing this so that individual workstations can update their own work and have this update the master workbook. After we link one cell, we would like to use the copy function by dragging
|
| filter dropdown menu so 2nd drop menu is customized | 04 Sep 2007 17:25 GMT | 1 |
I am trying to make a simple spreadsheet with dropdown menus where if you choose 1 item from the first drop down menu the subsequent dropdown menus will only display the items that pertain to the item in the first mene.
|