Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Formula for finding data from 2 worksheets04 Sep 2007 22:20 GMT9
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 think04 Sep 2007 22:08 GMT1
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 GMT7
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 formula04 Sep 2007 21:25 GMT4
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 column04 Sep 2007 21:21 GMT3
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 GMT1
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 Help04 Sep 2007 20:45 GMT5
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 time04 Sep 2007 19:46 GMT1
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 analysis04 Sep 2007 19:38 GMT1
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 array04 Sep 2007 18:56 GMT1
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 format04 Sep 2007 18:15 GMT2
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 data04 Sep 2007 17:42 GMT2
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 range04 Sep 2007 17:42 GMT2
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 sheets04 Sep 2007 17:34 GMT2
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 customized04 Sep 2007 17:25 GMT1
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.