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 / November 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Preventing user entering duplicate values in a cell range30 Nov 2005 20:00 GMT1
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 percentages30 Nov 2005 19:38 GMT2
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 it30 Nov 2005 19:23 GMT1
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 hyperlink30 Nov 2005 19:23 GMT1
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 help30 Nov 2005 19:21 GMT2
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 statement30 Nov 2005 18:59 GMT2
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 continuously30 Nov 2005 18:56 GMT3
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 Popup30 Nov 2005 18:51 GMT1
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 GMT6
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 GMT3
How do i get a number to leaing to the next full number?
Eks:
5,69 = 5
4,31 = 4
Run-Time Error30 Nov 2005 18:15 GMT2
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 selection30 Nov 2005 18:13 GMT1
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 cells30 Nov 2005 18:02 GMT2
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 GMT2
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 List30 Nov 2005 17:38 GMT4
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 ...
 
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.