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 / December 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Auto Filter With Auto Complete Ability26 Dec 2007 20:45 GMT1
Merry Chrismas
I have a list From A2:A8 -  Sunday,Monday, Tuesday,Wednesday, Thursday,
Friday, Sunday
I create a Col Head on A1 and Use AutoFileter, so everytime, when I click
Paste Data To WordPad TXT File26 Dec 2007 20:19 GMT1
I have a fairly simple macro that copies data from a few sheets and
consolidates it (via paste) into one sheet.  I know what to copy this
consoldiates data in this sheet (say A1:G65) and I want to copy it and paste
it into a wordpad document file (NewData.txt) and save the txt ...
Building pivot tables in Excel 2007 based on existing pivot tables?26 Dec 2007 20:05 GMT4
So I just installed Excel 2007, and other than the initial shock of
interface change, its seems pretty good.  I like that the prior Office
keyboard shortcuts still work.
I've been going though some of the Excel features/commands I commonly
Command Button - Macro to print to pdf, then send pdf to email.26 Dec 2007 19:36 GMT1
I have a command button in my Excel spreadsheet where it will look at the
email address typed into a specific field and email the excel file to that
email address.
What I want to do is when I push the button, First have the page print to a
Sample Size and Confidence Interval26 Dec 2007 19:30 GMT2
Situation:  The Hospital Administrator came to me recently and asked "how
many patients out of a group of sixty did he need to contact to ensure enough
were notified of a possible discrepancy in their medical records(?)".
Since this was non-numeric data, and most models are built ...
Combine month day and year from separate columns in to one cell26 Dec 2007 19:22 GMT3
I have the month (October), day (3), and year (2005) contained in three
cells.  I want to combine them into one cell where I can have the date as
10/3/2005.  I have been unsuccessful using concatenate because I cannot
change the format of the finished project from 10/3/2005 to ...
Conditional Formating26 Dec 2007 18:58 GMT3
Excell 2003.
If the results in "Say" cell Q12 is <= 0 then B12:Q12 all of the text turns
red or the background cell color changes to grey...
Conditional formation is great but when there is a loto of columns I get
How can I vary the row number or column alphabet depending on my n26 Dec 2007 18:46 GMT7
Example- Varying row number.
If I need to look up cell A(x) where,
A is the column alphabet.
x is the variable row number.
IF OR Formula Help26 Dec 2007 18:43 GMT1
I'm having trouble getting this formula to work, what am I doing wrong?
=IF(OR(C11={"None";""}),"",VLOOKUP(A11&"-"&F11&"-"&G11&"-"&b11&"-"&c11,'Writing Charges (2)'!f3:g237),2,0)*I11)
How do I convert existing excel numbers to negative?26 Dec 2007 17:53 GMT1
I have large amounts of excel data that i need to convert from positive to
negative.  Is there a way to accomplish this?
Thanks.
Chart Wizard Options26 Dec 2007 17:42 GMT2
When creating a chart in Excel 2003 I am offered the option of either a “new
sheet” or as an “object in”.  How can I lean about the pros and cons of these
choices and what each does?
IF and Then in Excel26 Dec 2007 17:26 GMT1
I am trying to compare two different cells in two different worksheets.
If the value in A1 in sheet1 is in any of the cells in in sheet2, then value
in B1 in sheet1 should be equal to value in C1 in sheet2.
Referring to first cell in a range26 Dec 2007 17:14 GMT5
Hi Friends!
I am trying to write down my very first custom function code. The function
already requires the user to insert a range. Now, I also need to use the very
first cell of the range inserted so.
polynomial growth trends26 Dec 2007 17:12 GMT3
Does anyone know how to project polynomial growth trends in excel - ie a
growth rate that initially accelerates and then tapers off after a period -
to trend towards an absolute population size (no further growth) after a
further period.
how to use if and then in excel26 Dec 2007 17:04 GMT4
I want to confirm that if a2 in sheet 1 is equal to b2 in sheet2 then a3 in
sheet1 should be equal to b3 in sheet2. I am trying to use the if and then
conditions for the same but i believe i dont know the right syntax to get
there.
 
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.