Mac Forum / Applications / Excel / July 2005

If I have a grid with nine squares, what formula can I place in a cell to
indicate that there is a duplicate value in one of the squares?
I don't see how I can use validation to effect this.

Help!
Is there a way to e-mail a single excel sheet and not the entire workbook? I
have students grades in a workbook and need to e-mail weekly updates.  When
I try. The entire workbook is sent even though only one tab is highlighted.

{=AVERAGE(IF(($J$12:$J$10786>R1)*($J$12:$J$10786<=R2),$S$12:$S$10786))}
In the above, column J is a column of values
R1 - R5 is a list of values in numerical order 150, 300, 800, 5000 etc.
Column S contains percentages

Textbox text
Several questions about Textbox
In a door schedule I am working on, project details (name, job no, drawing
no, date, etc) are entered in B1:B7 of the Input sheet and I need to

For info, I had some trouble when importing data in Excel v.X from a
FMPro v.5 file. Excel crashes and returns the following message:
"FileMaker Pro error: Object not found". Problem is caused by the
number of characters in the name of the FileMaker Pro file. File name

Does anyone know how to install the Analysis Toolpak add-in in Excel x
for mac?  I can't seem to find it anywhere on the internet for free,
and i cannot find my Excel installation CD,
Thanks

Hi to all!
I want to change the value in a cell from 1 to 10 in steps of 0.5 by
using a spin button. After placing the spin button, I Ctrl-click the
button and I point to Format Control. On the Control Tab one can set a

I wanted to calculate age of a candidate in Year/Month/Day format. What
is function to be used in Excel to get the result in Year/Month/Day
format. I have the date of birth of the candidate and wanted to have
the result for a given date.

How do I create a web query in excel on the mac?  I can't seem how to
create one only run an existing one.  I've resorted to creating the
query on my PC and then copying the query file over to my mac - but
even doing this the mac version of excel returns the whole page, not

My main workbook is constantly going behind the toolbar.  I resize --hit
green button-- and it's ok for a few hours and then the problem repeats.
Happens in word too.
Kevs

I have a document that list serial numbers.  (in a column)  for software
keys.
One on them used to come out:
4.88312E+14

I just moved my dad over from a Dell to a shiny G5.  However, Excel has
a problem with cells which are linked to other files.  Obviously paths
on windows are not the same as paths on the mac, but the dialog to
change the links doesn't work.  Here's what happens.

I have suddenly started getting a message that states 'Cannot empty the
clipboard' when i try to copy cells in any worksheet.  If I OK this and
carry on Excel crashes and either hangs for a while or immediately
closes down.  I have checked the help functions and there is no

Is there any way to change the border color of the active cell in excel
for mac 2004? The default selection is too light for my poor eyesight.
Thank you.

I'm not very good at Excel.... Excel 2004 11.1.1, Panther 10.3.9
I have a list, as below but longer, in two columns for weekday and date. I
managed to get AutoFilter--Custom Filter to show only Mondays and Wednesdays
and the associated dates.  Now I am having difficulties setting up ...