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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Pictures adding & removal08 Oct 2007 16:14 GMT3
I use a vba-button and function to add logos in a worksheet.
Everytime I use this button, the old logo is being overwritten by a new one.
I need to change the code so that the old logo is deleted before the new
one is placed.
High = 408 Oct 2007 16:10 GMT7
Someone help!  I need to know how I would do this i want to creat a formula
so that when i type in High it will equal 4 or Medium equal 2 or low equal 1.
So  for example:
= IF(4,High;2, Medium;1,Low=()) - This doesnt work  What i want is to add
Find and Replace08 Oct 2007 16:03 GMT6
I'm using Excel 2003 with all latest updates.  When I use the Find & Replace
function, if I click on Find I have three options in Look In -- Formulas,
Values, Comments.  If I select Replace I only have the Formula option in Look
In.  Can anyone tell me how to fix this.  I need to ...
Formula Countif Index Match08 Oct 2007 15:55 GMT2
I'm using Excel 2003 and this is my first post to the discussion group. I'm
trying to help a coworker and don't have a lot of experience working with
formulas.
I've searched the discussion groups, etc. and have tried several different
Copy and Replicate exact formulas08 Oct 2007 15:08 GMT4
I have a range with formulas in, say A1:F50.  I want to copy the exact
formulas over to G1:L50, but if I select the range and copy and paste,
it changes all the values in the formulas, when I want an exact
replica, not adjusted ones? How can I do this? At the moment I'm doing
Insert a letter in front of number in every cell?08 Oct 2007 14:50 GMT3
I have a whole column of numbers which I would like to add a letter to
in the beginning.  For example, if the cell has the number 2350, I
would like to change the cell to B2350.  How do I do this without
manually changing the data on every cell?
link text08 Oct 2007 14:49 GMT1
I have two sheets in a workbook. Sheet 1 has six columns of information about
projects. One of the columns contains one or zero indicating status [open or
closed]. Sheet 2 has array formulas that copy only those rows from sheet 1
that have open projects. In addition there is a ...
ExcelMedic.com08 Oct 2007 14:43 GMT1
ExcelMedic.com can provide a full  range of
Excel solutions to fit your needs.
ExcelMedic.com charges an hourly rate that is
guaranteed to be 15 percent less than other
Spreadsheet within a spreadsheet08 Oct 2007 14:26 GMT7
I have a series of documents (system function lists) in Excel that vary in
column width. Above each of these, I have to insert a 'Header' that is 8
columns wide. When I insert this 'Header', it needs to fit across the table
without changing the column widths (no matter how short ...
Refer upper field08 Oct 2007 13:59 GMT1
Is there any function that can refer upper or beside field without defining
specify field?For example,i'm select row A1,then i use Alt+G to select blank
field,then the blank field will refer the value/text each of there upper
field,example field A2 refer A1,A3 refer A2,A4 refer ...
Is there a keyboard shortcut for using Paintbrush?08 Oct 2007 13:54 GMT8
Signature

Mike

where is the crystal reports wizard in MS Excel 2007?08 Oct 2007 13:27 GMT2
Is there an easy way to import data into Crystal from within Excel 2007?
Search and go to cell08 Oct 2007 13:26 GMT2
I have workbook of names and some information for them all. The first
worksheet is a Contents page.
On that contents page I want people to be able to enter in a persons name
and have excel search (and goto, or bring the infromation to) a name/cell.
Conditional Formatting - further assistance required08 Oct 2007 13:16 GMT2
I require to format 17 cells in a row ie: A1:Q1 to turn red, dependent on
text being inserted in K1
Please help,
Thanks
IF(ISBLANK) with other criteria08 Oct 2007 12:51 GMT5
I use ISBLANK all the time as I don't like to see div or num errors in a
cell  :)
I now want to add something to it, but not sure how ...
The formula in CELL E6 is this   =IF(ISBLANK(D6),"",LOG(D6))  ... But when I
 
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.