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 / New Users / March 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
sumif using the now() function31 Mar 2006 22:49 GMT6
I am trying to sum numbers using the NOW() function as my criteria, however
no luck.
sumif($D$1:$BC$1. ">=NOW()", D2:BC2)  Any help would be appreciated.
Thank you
Charting and ignoring 0s31 Mar 2006 22:04 GMT4
I have a years worth of data that essentially looks like this:
Date        P&L        Fees
3/1/06        $4        $1
3/2/06        $466    $14
Auto filter by background color.31 Mar 2006 22:03 GMT2
I use the auto filter all the time.  I'm looking to highlight, follow ups,
pendings, etc. then be able to use the drop down menu for "all red," "all
blue," etc.
I can't seem to figure out how to do it.
Mystery - Excel treats the same cell contents differently31 Mar 2006 21:27 GMT6
I saw a document somewhere in the past couples of weeks, which I wanted
to review in greater detail but now I can't find it. It stated a
problem within Excel where cell contents appear to be the same to the
eye, but not to Excel. Can anyone point me in the right direction!
undue merge and centre31 Mar 2006 20:45 GMT3
I am trying to undue the "merge and centre" of my title.  I would like to
make the range smaller.
Is this possible?
Thank you.
using excel for the first time,want a document frowhere can learn31 Mar 2006 20:42 GMT3
using excel for the first time,want to know the basic about excel from the
start,if a document is provided that would be more usefull
Regards
pooja
excel work books open backwards now31 Mar 2006 19:30 GMT2
Hi, new here, looking for some help, excel xp, default blank workbook now
opens with the colum begining at A on the right, and the row headings on the
right, so to me it appears backwards to what it normaly, or used to open
with, i've tried reinstalling it, and no change, i tried ...
adjacent cells select themselves31 Mar 2006 18:26 GMT2
We've had several users experience an issue where they select a singl
cell and then when they move the mouse all of the adjacent cells selec
themselves automatically. The mouse is being operated correctly.
We've reinstalled Office 2003 and that fixes the problem for a whil
Embedded Excel file in Word31 Mar 2006 18:08 GMT1
I have an embedded Excel worksheet in a Word file (2003).  In the Word file,
there is a table that is linked to the embedded Excel worksheet.
If I double-click on the table, it opens Excel and I can make changes.  
However, if I attempt to do that while Excel is already running, I ...
date format using dot / period31 Mar 2006 17:56 GMT1
I have a user that did a custom format for a column to be mm.dd.yyyy.  When I
type the date using slashes - Excel recognizes the data as a date.  However,
my user typed the data using dots.  I told her to find and replace the dots
and make them slashes to make the information ...
Return Value in Column 2 Q31 Mar 2006 15:52 GMT1
I have a table which contains 2 columns and 30 rows of Data
Col1 = Sales
Col2 = ManHours
I wish to "lookup" a value that is input into A1 (which will be a sales
print 4 alternate columns31 Mar 2006 15:48 GMT1
hello community
yesterday, 29th, a helpful person assisted me in solving - printing a column
and a selected area - that was fine and successful.
now, what happen when I wanted to print alternate columns only - i tried
How do you perform lookups when the info is always moving?31 Mar 2006 15:42 GMT3
The way i've been doing it is to rename the ranges so the formula can
calculate.  Is their an easier way?  I've been playing with match and index
arguments and i'm stuck.  I don't know enough about VB to create, only edit.
My Data:  (today it is from 3-5, tomorrow it may be from ...
index?lookup?match?if?31 Mar 2006 15:32 GMT2
I am making a spreadsheet to record compeditive times in an autocross.
Colums a,b,and c, contain respectively driver number, driver name an
car number.  More than one driver can drive the same car.  Colum
d,e,f,and g contain additional data.  column H contains imput of eac
conditional formatting31 Mar 2006 15:32 GMT2
how can I have a cell highlighted (light gray) if the cell contains the
letters Vol
ex: if a cell contains>             Vol 5  Chapter 3 xyz protocol
In this case I would like the cell to then automatically be highlighted
 
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.