I've spent a good part of the day working on a few pretty complex
array formulas.  I'd now like to add one that will create an array of
hyperlinks.   I thought I could do something equivalent to:
=HYPERLINK({"http://google.com","http://yahoo.com","http://

Why does my formula  =OR(O8<>"";H9<>"";1;0)  display "TRUE" when cell O8 or
H9 is empty? It should yield 0 (Zero).
It also displays and "TRUE" when these cells are not empty; it should yield
1...

I have a number in a cell that is the result of a formula.  The number
doesn't come out even such as 44.44 or 56.66
I need to use this number in another formula, but I want to use the
whole number (44, 56) not the decimal version.

I've a table with the cell range a1:AE28.
For the odd no. rows of the table, starting with the first row the
possible values are "DG", "YL", "DR" and "DB".
For the even no. rows of the table, starting with the second row the

Is is possible to set the conditional formatting of a cell to disply a
different graphic?
What I want to do is have three options (Increasing, Constant, Decreasing)
as validated data for a cell and have the cell display an Up arrow for

I have a list of data that I want to separate based on a customer
type.  I want all customers with a type of "HOSPITAILITY" or "HOTEL"
separated onto a new tab and then I want all customers that don't have
a customer type of "HOSPITALITY" or "HOTEL" separted onto a different

I'm working with Excel 2007, german version. I'd like to open my Excel files
which I have written with older Excel versions but all Excel files with
macros generates the following error:
"Diese Arbeitsmappe hat ihr VBA Projekt, alle ActiveX-Steuerelemente und

I have tried to submit questions before, and did get much help. I am going to
try this another way.
I am a supervise approx 15 to 20 techs, and on a daily basis I get data
emailed to me on a excel spreadsheet. This spreadsheet contains data for the

Is it possible to e-mail to a colleague just Sheet 1 of a workbook?

I am developing an estimating spreadsheet that calculates labor hours. I have
built a separate 10 column and 6 row chart with info I want to pull into the
estimating spreadsheet. The colums are labeled as "Difficulty Factors" and
the rows are labeled as "Pipe Sizes". Each ...

My text is appearing on a Row as if it is 'topped off'. I have checked
the Aignment and it is set to General-Bottom. I have no merged cells
or text wrapped.
My font size is 10 and Row height is 12. I've even tried copying in

For those of you who work with small companies that create
spreadsheets containing VBA macros, how do you handle the warning that
Excel displays when you open a workbook?
I know you can use SelfCert.exe to create a personal digital signature

Trying to create my own office pool sheet.  Able to create drop-downs for
teams across the sheet.  Want to have won-loss record at bottom of columns

Working with Excel 2003 - I am trying to place a previous work spreadsheet
into another workbook - however, when I attempted to move and copy I can only
insert one worksheet into the other workbook.
Please advise

I'm doing an online schedule and need to count how many shifts people work.  
Each month is a sheet and each employee is on the same row each month.
They will either have A (shift 1) B (shift 2)  X (off)  H (holiday) ill
(sick day).  Right now i've created a bunch of countif ...