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 / February 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Wrapping text15 Feb 2008 23:28 GMT5
We have Microsoft Office 2007 running on Windows XP Pro. We use excel a lot
entering text into different cells. We frequently have problems with text
not want to wrap within a cell. Have you seen this or do you need to see a
specific example?
Formula Help15 Feb 2008 22:26 GMT1
Not sure how to do this, I need to add Column A that equals "abc" then
multiply column B by Column C.  There could be up to say 12000 cells in
column A.  So what I need to do add up anything in Column A any cell that
equals the text value of "abc" then multiply the cells in ...
Cannot check the check mark box in cell15 Feb 2008 22:24 GMT1
I created the check mark box, renamed it, and then saved it off.
I basically want to use it for a survey, but when I go to click on the box;
it highlights the entire text box and that is about it.
Thanks for any help!
networkdays function15 Feb 2008 21:57 GMT2
I'm trying to use the networkdays function to return the number of working days between 2 dates which seems like the correct function however when I use 2 dates, 7 days apart, the function returns 6 rather than 5 i.e monday to friday working.
Am I doing something wrong?
Thanks in ...
I have a 38 digit # and I want to subtract 27 thru 32 from 33 thru15 Feb 2008 21:49 GMT2
any way to do this.
The 38 Digit # is in one cell.
Thanks!
Bill
Update link cells without open up source document files15 Feb 2008 21:25 GMT1
I got "#REF!" error messages on linked cells after choosing "update" option
when opening up a file.  This error messages will disappear and linked info
updated after source document files are open.
How can linked cells update automatically without opening up source doc files?
Q.115 Feb 2008 20:54 GMT3
how to format a cell in a 'sorting column' so that every time i put an entry
in the cell  it will be sorted in its right position- in the column, i guess
it need to be after I finish entering all the other cells in the row? how
please?
Wildcards with numbers....* & ? not working15 Feb 2008 20:43 GMT2
We have a time sheet program and for what ever reason it rounds down at five
rather than up, like most of us are taught growing up. For example, if we end
up with a time in decimal format of 1.25 hours. it rounds this time back to
1.2. From 1.6 and above it rounds up. Now this ...
Excel code to call a macro when a certain value in a cell is     selected.15 Feb 2008 20:18 GMT4
I am trying to write code that will call a macro when the value of
cell is equal to a defined text.
Example:
If C28  = "Remind", then Call Macro_Name.
LookUp15 Feb 2008 20:10 GMT4
I am trying to use vlookup function for the first time:
One sheet has table as below. I've named the range for lookup as "RB"  
(Region Balance).
Region    koef    #Fl    Hrs    Amount
can u make a text in a cell to blink , or change it's color?15 Feb 2008 19:40 GMT2
thanx
bee
Average is dependent on conditions15 Feb 2008 19:32 GMT3
I have 30 months of data (from Sep 2005 to Dec 2007) laid out in columns.  
Rows are different names of employees.
I want to create averages for the each year from Sep to Aug so I that in the
end of August there would be Sep 05 to Aug 06 average, Sep 06 to Aug 07
Looup Value and Return a Range15 Feb 2008 18:46 GMT1
I want to lookup a value in column E and if it matches my lookup criteria I
want to return all the information in the corresponding row.
A=acct number
B=acct status
Creating New Formula15 Feb 2008 18:35 GMT1
I have a list of individual mobile numbers and a second list of the same
numbers but with each number duplicated several times. On the list with the
duplicate numbers I have their tariff info. I need to search for the
individual numbers on the duplicate numbers list and add the ...
Excel is rounding up my formula result15 Feb 2008 18:15 GMT4
I am new to this whole process and am spending too much time trying to
determine how to fix my problem. Any help would be greatly appreciated. I am
simply trying to divide a number by another and obtain the exact result of
such expanded to two decimal places. For instance 419.00 ...
 
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.