Mac Forum / Applications / Excel / June 2005

The following formula should return 4...
=SUMPRODUCT(--ISNUMBER({#N/A;2;6;#N/A;3;#N/A;#N/A}),--ISNUMBER(1/({#N/A;"
No";"Yes";#N/A;"No";#N/A;"No"}="Yes")),{5;6;4;7;8;9;6})
When the formula is entered in a Windows version of Excel, it returns

Hello, I have a workbook with some words that I would like to link to
pictures on a different worksheet. I know you can easily link from cell to
cell by highlighting a cell, then do insert.....Name...Define. You can then
create a hyperlink to that defined name.

Is it possible to get the coefficients to a polynomial curve fit without
having to graph the data and use "Add Tredline." I am looking for third
order polynomials and above. In addition, I have a large data set and
would like to generate a set of coefficients for each x-y set.

I've got an excel list that we're using as a sortable product tracking
list that has a space for an image on the left side of the columns, and
then addictinal cells for sizing and specs to the right of each product
and then additional rows of the same for each additional product.  ...

What is the best way to create ranking catagories of names applying for
a job position within a spreadsheet. Can they be color coded so that
you can pull the highest ranking after listing a large group of names
within a spreadsheet. For instance can all the reds, highest ranking,

I tried a simple "epsmach" test:
+-----------+-----------+-----------+-----------+

+-----------+-----------+-----------+-----------+

Given dates of anniversaries are in a column in an spreadsheet can XL give
an alert of a pending anniversary on start-up?
And when already running?
Ok I shall build in days in advance, appropriate to the event, but that can

Can anyone recommend a good book that I can buy to learn how to write
macros in Office? 2004?

Will the "VBA Converter for Excel" convert VBA macros from Windows
spreadsheets so that they work in Excell 2004 plus if I create Macros
in Office 2004 will they work in Windows version of Excel?

Here's my challenge. I have two excel lists with different data fields
(column headings). Both lists have one common column (a store number).
Is there a way to merge the two lists into a third list, and combine
all the data using the common column (store number)? Ie, append the

I recently upgrade my Office X to Office 2004.  I haven't tested out
new features, but I find noticable different when looking at the same
file in both version.  Actually, I open them side by side, having
Office X and Office 2004 (Excel) opened.  The fonts don't look as

I have tried several times to change a font on an Excel spreadsheet,
but each time, Excel shuts down and asks to send an error message to
Microsoft.  Is there some simple fix for this?
Thanks

I am trying to create a list of several names throughout the Country,
and create groups according to state. i want to include their email
addresses and web addresses, so that i can click on them from the
spreadsheet and open the browser to view website or send an email. Can

I get the strange error message whenever I use the Cut or Copy commands.  But
I click OK ... and then proceed to Paste in normal fashion.  So the error
message is mostly a nuisance, but perhaps a clue to a problem I should fix.  
Any suggestions ??

Excel (Office 2004) crashes constantly.  I thought Mac was supposed to be
more stable than PC? What gives?
Incidentally, I've got a PowerBook G4, 1.5GB ram, just upgraded to OSX
Tiger, using little overhead.  Using the Notebook view. It just keeps