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 / General Excel Questions / April 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Datedif formula18 Apr 2008 20:50 GMT3
I am trying to figure out the number of months between a start date and the
current month. I am using the formula =DATEDIF(MONTH(TODAY()),G4,"m") but it
is giving me the wrong answer. Ex. the start date is Sep-07 and it is
returning 1291 as an answer and the column is formatted as ...
Conditional formatting to color rowsbased on cell value18 Apr 2008 20:49 GMT1
How can I color rows based on the cell value of one cell in each row?  That
is, if I use conditional formatting to test the value of cells in column P, I
can color cells in that column with conditional formatting, but I want all
cells in each row to have the format of the cell in ...
External Data18 Apr 2008 20:19 GMT1
I had tried to import data from an access database.  It didn't work so I
delete the table and continued other tests.  I finally have thing setup the
way I need them but now when I iopen the spreadsheet it keeps giving me an
error about the initial data source.
Font Size Changes in Pivot Table Upon Refresh18 Apr 2008 20:13 GMT1
This is a really annoying problem that shouldn't be this hard.  I have
a pivot table in which I want the font size to be 12.  However, when I
refresh the table or do anything to it the font size changes back to
ten.  Not all the cells change, which makes the report look strange
choose+match!!18 Apr 2008 19:32 GMT1
given :
                    range A           range  B          range  C
range 44            1                    b                  xa
range 45            2                    b                  xb
Enhanced lottery question18 Apr 2008 19:21 GMT5
The rules of the game are this
Pick 6 numbers and you must keep this six numbers until someone wins.
assume you pick 1, 2, 3, 4, 7, 8
Assume that the lottery numbers in week 1 are
Getting the correct SUM answer18 Apr 2008 19:05 GMT1
Good morning,
I am having a lot of trouble with the formulas in a spreadsheet and
can't quite figure out how to word what it is that I need. Hopefully
this will at least come close enough to get a little help. =/
Multi Part Lookup18 Apr 2008 18:56 GMT3
Store #      Jan                    Feb                    Mar
1          471,374           488,292        
3          -     -    
4          488,295           470,050    
Email with excel18 Apr 2008 18:29 GMT1
Here is the code that i have so far.  The range A1:A2 is where emails
are stored.  The range will become larger when this works correctly.
I am trying to email multiple recipients based on information that I
have in cells on a worksheet.  Any guidance woudl be greatly
Color and Date18 Apr 2008 17:53 GMT1
I have date column and  i need Friday in red color and rest of the week days
in blue color
How can I do that?
COUNT and SUM with multiple criteria18 Apr 2008 17:50 GMT2
Two seperate functions I'm having problems creating.  
First, I need a COUNT of the number of cells meeting TWO sets of criteria.  
For example, "column A=final" AND "column B=14".  
Seperately, I also need a sum of values in "column C" for the same
Checkbox to Unhide Rows18 Apr 2008 17:43 GMT3
Is it possible to use a check box to 'Unhide Rows'?  What I would like to do
is have a client select a check box(es), then press a button I have inserted
into the spreadsheet to run a macros.  This macros would Unhide rows
according to which boxes have been checked.  Or is there ...
HOw can I copy a protect cell to paste somewhere other than excel?18 Apr 2008 17:40 GMT1
I am trying to copy a sheet from excel into powerpoint. I want to protect
certain fields and leave other open. I know I need to lock and protect them
before I copy/paste, but I can't select the protected locked cells. Any ideas.
Thanks,
HELP! HOW TO COMBINE CHARTS IN MS.EXCEL18 Apr 2008 17:39 GMT1
Hi. Im a business student but im taking computing class as it is
compulsary. i have an assignment to  combine 2 charts. i have 2 data
sets ( sales 2007 and sales 2008). The sales 2007 is in sheet 1, while
sales 2008 in sheet 2. i have to make 1 chart showing a comparison
Digital Signature18 Apr 2008 17:07 GMT1
How do you digitaly sign a document so you can veiw the signature after you
print the document.
 
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.