I have a spreadsheet with multiple hyperlinks.  I want the hyperlink to
remain active, but I don't want it to be automatic when someone clicks in the
cell.  I want them to have to follow a specific set of commands to link to
the website.  Can anyone help?  I've opked around and ...

Ok, I have a list of names in the fomrat John A Doe, Joan Bennett, etc (no
commas, some have middle initial, some don't).  How do I get Doe John A, and
Bennett Joan (last name first name middle initial - commas OK)  I tried the
Pearson example, but it had commas and the last name ...

I need to analyse some data that is held in an Access database, but I want
to do this in Excel.
I have the data in an Access Query.
My data is about 7500 records and increasing by 200 records per month.

Hi Folks - I've got a mental block .... How can I convert the elapsed time
of 07:15 (seven hours and 15 minutes) to the decimal format 7.25 (seven and
a quarter hours)? Thanks.

I'm trying to compare account numbers from two worksheets on a monthly basis,
and then return a value for a second account number in the second worksheet.
The account numbers vary each month. Thank you.

Hi, i have a question about stopping a function at certain specified point.
i'm trying to simplify the list with data entered as follows: "xxxxx xx      
xxxxxx"
i just need the first part, so i want to trim the part after the long space.

Expert VBE help for cell color change
I need VBE/code help for changing color in a worksheet if a condition is met.
I’m working on a spreadsheet for the Master Schedule at the high school
where I work.  I have created 10 worksheets that help us track # of teacher,

Excel allows a defined name to represent an array range or array constant. It
allows a name to represent a formula which is then evaluated to return a
value.
Why can I not define conditional arrays like these:

I have a autofiltered data range from which I calculate a number of subtotals.
I.e: column 2 filtered to show "tool A"
- how do I get the value "tool A" to a cell outside the filtered data range
by using a worksheet function?

I have been using the yearfrac calc but have notised the following when you
use periods across a leap year:
Date    Days     Yearfrac     Yearfrac from start date
        per period   

want to setup formula using networkdays through which end date which is 30
workingdays from  start date can be calculated.

Is there any way to next an "or" function within sumproduct?
I have about 1000 lines of data representing individual cases.  I want to
create a formula that uses 3 columns A, B and C: Return the # of cases that
demonstrate a value greater than x in column A or y in column B.   In

If I have a results column of positions that something has finished,
and then I have a column of a persons guesses of where the finishing
positions would be. How do I calculate the difference between the
persons guess for each guess and the actual result please?

I have an Excel Workbook with about 30-40 sheets with equal structure. Every
time I make changes in some of the input values, I have to use goalseeking on
each of those 30-40 sheets to make the model right. Is there av way to
automate this process on every sheet in my workbook? ...

I have order numbers in one column, items in another and amount in another.
The sheet is prepared according to the item. But, I would like to calculate
what is the amount for each order.
I could do it with the help of Pivot, but i hav some more fields required