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 / January 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Cardiology30 Jan 2004 22:49 GMT3
Please, could anybody assist me? I'm about to enter the university to study medicine. I plant to later specialize in Cardiology. Please kindly explain all it requires and give me all relevant information.
changing the background color on a single column30 Jan 2004 22:32 GMT2
I am trying to change the background color on one column.  
The only thing it will let me do is change the background
on the whole table.  Can someone please tell me how to do
this?
find on multiple worksheets30 Jan 2004 22:27 GMT2
Is there a way to find data on multiple worksheets instead of searching individual worksheets?
100% eliminate the "Save before quitting?" message 30 Jan 2004 22:21 GMT6
In my workbook I have:
   ActiveWorkbook.Saved = True
and it works. However, there are two instances when it does not work and I
still get the "Save before quitting?".
weekly  top 50 titles _newbie,please help!!!30 Jan 2004 21:01 GMT5
Hi.
I am tracking the usage rankings of a number of links for
a web page over the course of a week.
Each day has it's on sheet.
Looking for "StDEVIF", if it exists30 Jan 2004 20:32 GMT2
Does excel contain a formula operator similar to SUMIF but would utilize
StDEV in place of SUM.
I need StDEV to ignore 'empty' formulas in my sheet which return
#DIV/0!
Detecting invalid links30 Jan 2004 20:18 GMT6
A quick question about links, probably with an obvious answer for thos
in the know.
I want to avoid a value being displayed if a link is not valid becaus
the file does not exist. Is there an 'If Exists' command or similar?
more help - Formula to check values30 Jan 2004 20:03 GMT1
maybe someone can help - I am dealing with a negative
numbers:
if the value in cell 1 = -1.0 and lower (i.e. -2.0)
then "CR" should display in cell 3
how to change extension of unopened file30 Jan 2004 19:27 GMT2
I copied an excel file to a CD and it copied it with an
ink extension instead of xls.  How do I change it?  I
cannot open the file to save it as anything else.
Rita
vba - need to find the type mismatch in this line of code30 Jan 2004 19:22 GMT2
While Worksheets("Log-Import").Cells(counter, LogCol).Value And
Worksheets("Log-Import").Cells(counter, UsernameCol).Value And
Worksheets("Log-Imports").Cells(counter, DayCol).Value <> "Logoff" And
username And Cells(counter, DayCol).Value
footers30 Jan 2004 18:48 GMT1
does anybody know a way to insert a graphic file into the
footer of an excel sheet so it appears at the bottom of
every page?
this might be a little basic, but i can't seem to figure
Duplicate searching through multiple columns, rows30 Jan 2004 18:28 GMT1
I just did a search through the newsgroup but didn't find
anything specific to this. I'm trying to look for
duplicates so that it would recognize ROWS A and C as
being duplicate (see below). Is there any way to do that?
IF Formulas to Find Text String in Specified Range30 Jan 2004 18:28 GMT4
I am hoping that someone can help me out here.  I am
looking for an IF formula that will allow me to search a
specified range for data that does not = "--" and then
return that value in a specified cell.  Does anyone know
converting imported numbers30 Jan 2004 17:51 GMT4
I have imported a text file containing numbers that I need
to change/move the decimal left 2 places i.e I need
convert/change 123 to 1.23, 123456 to 1234.56 etc. for the
entire sheet. Any suggestions?
Include error checking30 Jan 2004 17:47 GMT2
=IF(BL484="saleable",(SUBSTITUTE(TRIM(BS484&" "&BT484)," ",",")))
I want to include error checking so that if BL484 does not contain a value
it will not return FALSE
Thanks in advance!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.