I'm trying to lookup a number that has a really long decimal figure:
eg: 2.33334444555666777
Is there anyway I can search for it by just typing "2.3333" instead of
the whole long number?

I have,
A1: 1       D1: 2
How do I write the function that if say A1="1", then G1 will take
whatever value that is 3 collumns to the right of cell A1 (in this

I have a workbook that has 50 sheets.  I want to create a loop that will
copy each individual sheet to its own workbook and save it with a name.  
This is what I have so far.  Any help would be great.
   Sheets("1").Select

I want to use array formula's to reduce a very large spreadsheet. VBA
and macros are not to be used, due to the webpublication of this
spreadsheet.
Is there a way to reduce a simulation run with repetitive formula's,

How do you copy every nth column of a row to the first cell of the row?
The values in the columns are string values and I'd like to place a
space between every value as it's inserted into the cell.
There are thousands of columns (using excel 2007) and each row is using

can you add more that 30 cells?  the cells are in the same column but i
different rows.  there are about 50 that i need to add...  the formul
that i am using will not let me add more that 30 cells...  =SUM(
--

I am wishing to create the shading as shown on the 2nd image/chart on this
page:
http://office.microsoft.com/en-us/assistance/HA011097991033.ASPX
I'm trying to get the diagonal shading.  Everytime I try to shade an area,

Hi im trying to do something that I though would be pretty simple, but
is complicated by the way excel handles dates.
In a column I have formatted Dates like this...
12/05/04

I have a pretty complicated question, it's probably easy for wel
versed users, but I'm not sure what the cleanest way to do this is
Here's what I'm doing. I'm taking a column of numbers, then in th
column next to it I want to do the following

I run Win2K with Excel 2K
I require a macro that when I place a number in a cell that the curser then
jumps to a particular cell (or range name if that is the better way to do it)
ie;

I am using Excel 2003. Everytime I copy a text format e-mail address from a
cel, it automatically turns it into a hyperlink. How can i disable this
feature?

I am trying to do a simple task of labeling a row as Q1,Q2,Q3 or Q4
based on the month value of an existing date. I am using the following
IF(AND function but get an error statement which I cannot resolve. Any
suggestions would be welcome. Thanks.

All of a sudden I don't hear any sounds with excel. When I go to control
panel and sounds I can click on the test button for all the normal sounds,
critical stop, default beep, etc. and I can hear them but those same sounds
for alerts in excel I get nothing. All other sounds work ...

Simple question that is driving me crazy.  I'm making a table
containing text and numbers.  One of the cells in this table has 1459
characters.  For some reason, the last couple sentences won't fill the
bottom of the cell; instead, they're cut off.  I can only see them if I

I want to conditionally format blank cells in column B to blue when the
value in corresponding cells in column A contain the word "Custom".
However, once I place a value in a blank highlighted cell in column B I
then want the formatting removed.