Re: Formula Help
Oops.. read your question wrong... use this:
E1==IF(ISNA(INDEX(Sheet1!$AA$1:$EE$100,MATCH(A1,Sheet1!$AA$1:$AA$100...I am looking for Mac 10.4.8 Office Software
Operating System: Mac OS X 10.4 (Tiger)
I saw on the system requirements for the Mac Office that you need 10.4.9 or later. Mine is running on 10.4.8. Where do I find the Office software that it compatible with my mac? I need Microsoft Office on my macbook for college and I cant find a compatible one anywhere.
I think you're mistaking the order of things :-) What needs to be done is to
update your installation of OS X, not 'downgrade' Office. Use this link to
Apple Downloads & retrieve the OS X 10.4.11 (Tiger) Combo Update.[Yes,
you're that far behind. Updates to OS ...Service Calendar View 11-14-06
The default time view in Service Calendar is 12am - 12am; anybody knpow how
you can change this to working hours ?
...Updating "Office" from "10.1.x" (office version not Mac OS version) to current "Office" version
I cannot determine the update path to take. Tried to install 11.3.7,
11.3.3, etc(no go). Where do I start??
If you have 10.1.x, then you have Office X, and you need the updates
that say Office X or Office 10.1.9
The ones for 11.3.7 are for Office 2004, the newer version, which would
> I cannot determine the update path to take. Tried to install 11.3.7,
> 11.3.3, etc(no go). Where do I start??
On 9/25/07 6:36 PM, in article
<k.mcquaid@g...Re:Changing dialog size
I want to change my controls size when the user change the dialog size.
But the dialog can not receive the message-WM_SIZE. How can I let the OS
system send the message-WM_SIZE?
...Help Installing or Re-Installing .NET Framework 2.o
When trying to installing this update, I get the error message:
Initializing installation... done!
Installing Microsoft .NET Framework 2.0 Service Pack 2 Security Update for
Windows 2000, Windows Server 2003, and Windows XP (KB974417) (update 1 of
Microsoft .NET Framework 2.0 Service Pack 2 Security Update for Windows
2000, Windows Server 2003, and Windows XP (KB974417)
Trying to learn servers - need help with this problem - Thanks to all.
See the "How to obtain help" section of
For home users, no-charge suppo...Sumproduct formula 02-20-10
Is there a smarter way of doing this SUMPRODUCT formula?
I'm finding different duration totals and multiplying the total by a
different ratio for each duration
find the 30 durations and multiple by the 30 ratio of 0.5 (cell name =
find the 5 durations and multiple by the 5 ratio of 0.05 (cell name = 'five')
All named ranges are the same size i.e. cells 35:76
$D217 = the market to search for in
the named range "market" = range (A35:A76)
BO198 = the duration to search for in
the named range "duration" =...Unable to access Mailbox of Re-Enabled User
Hello! We are running Exchange Server 2003 SP1, and the issue I am
experiencing is that if we disable a user account and then re-enable it to
get the mail, the mailbox won't be accessable. I have even reset the users
password, logged in as him/her and it still won't work. It keeps prompting
for authentication in Outlook (2003). The only way I have gotten it to work
is to delete the mailbox, remove all Exchange attributes from the User
Account, and then reattach the mailbox to the User Account. Any thoughts as
to what the problem is? Thanks!
Check the permissions on the ma...Office 2007 05-06-10
I have a customer who uses Office 2007 Excell and word for the most part. He
opened Excell yesterday and the colors in his spred sheet is gone and the
task bar on top is all grayed out and the style is different. I know from
using Office my self that the task bar background on top is white with
colors. What could have caused the problem and how can I fix it. I
uninstalled Office and rebooted the system. I them did a full install of
Office but still have the same problems.
Its over my head - sounds like a system issue - a corrupt dll file or similar?
Have you tr...Windows Media Player 01-03-10
Error Message COOD10DA, original error 80040155
...Have a client on GP 6.0 with Pervasive -wants to go to Version 10.
IIRC 7.5 was just 7.0 with the service packs and 6.0 to 7.5 was no
problem. I think all of the conversions that I did were 6.0 to 7.5 and
then Pervasive to SQL Server 2000. Then, most of my clients waited and
jumped from 7.5 directly to 9.0 again, without any problems in the
The interface change that started with 8.0 has been a major sore point
for long time users as it is far less efficient than the palette system.
Mike Quirke wrote:
> Any suggestions?
I double checked, and I do have the sequence...Outlook 2002 10.2627.2625 Clear Calendar
How can I clear the Calendar in Outlook? Besides
uninstalling and reinstalling the program? I want to
clear all calendar entries only -
Thanks for any help you can offer
Switch to an unfiltered table view of your Calendar folder, such as "By
Category". Select all items (CTRL+A) and press Delete.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
RL Hastings wrote:
> How can I clear the Ca...Feb 10 live MSFT chat: RMS 1.2 Hardware Configuration
This is Michelle, editor of the Microsoft Business Solutions Community site.
I want to let you know that this week, on Thursday, Feb. 10, at 11 a.m. PST,
we'll be hosting a live chat on RMS 1.2 hardware setup. Here's a description
of the chat:
Hardware Configuration in Microsoft Retail Management System 1.2
February 10, 2005
11:00 A.M. Pacific Time
Have questions about setting up and configuring the hardware your POS system
uses? In this live chat, Microsoft Retail Management System developers Balaji
Balasubramanian, Josef Schauer, Dan Hanke, and Sylvester La Blanc wi...Formula error since 10.5.6 update ...
I have been working with a spreadsheet for years without any problem
of this sort. Since my recent 10.5.6 upgrade a part of a formula
not return a correct result.
My problem seems to be related to the incorrect result of this part
my formula: TEXTE($N$5;"dd-mm-yy"). In this example, N5 is equal to
"31-10-09". This formula should return : 31-10-09 It returns
yy". Funny, the "31" is replaced by "dd" and "09" by "yy", while the
month number is correct.
Any idea with this is all about ? ...How do receipts get re-created in the Journal?
Does anyone know how receipts get re-created when you see them on screen? I
think the answer to this question will help as I create custom receipts.
In other words, when I look at an existing receipt in the journal viewer, is
it pulling data from the tansaction table, item table, etc, or is all the
info from the original receipt stored somewhere.
One of the mysteries I am trying to solve is why the discount code and
serial number show on the printed receipt, but not on the viewable receipt.
Steve, the receipt you view in the journal is taken from a compressed image
of th...Mailbox Manager #10
We have a recipient policy that's giving out SMTP addresses. Now we decided
to implement a policy to remove emails on users' Deleted Items that are older
than 30 days.
So, on the current recipient policy, we added the Mailbox Manager settings
on the property page. On the policy itself, we selected the action to Delete
Immediately for the Deleted Items that are over 30 days. I also set it to
run on 12:00AM Sunday.
However, the result is shown below:
The Microsoft Exchange Server Mailbox Manager has completed processing
Started at: 2005-06-19 00:14:01
Completed at...multiple formats in a cell 11-17-09
I'm trying to find a way of displaying the content of a cell as either a
number or a percentage depending on the output from a lookup. I'm struggling
to find a way to do this in Excel 2003. Can you help please?
Provide some examples about your data and how would you like to get the result…
> I'm trying to find a way of displaying the content of a cell as either a
> number or a percentage depending on the output from a lookup. I'm struggling
> to find a way to...GP 10.0
Based on postings in the discussion group some people already have ver. 10.0
I understand it was released around June 18th. We are in Vancouver Canada
and have not received yet.
Just wondering if others have or have not received and when they received or
expect to receive.
We are up to date on the enhancement program.
It is downloadable from CustomerSource. The CD’s have not shipped that I am
> Based on postings in the discussion group some people already have ver. 10.0
> I understand it was released around June 18th. We are in Vancouver ...No Dex.ini in Release 10
What replaced the Dex.ini file in GP release 10?
In prior releases, we could copy this file the each user's Citrix profile in
order for them to use their default printer. How do we do this in release 10?
I am not running 10 yet but this was taken from a previous post in this group.
"The Dex.ini (and other files which need write access) have been moved to a
Data folder. This is because under Vista applications normally do not have
write access to the Program Files folder and sub folders. The Data folder
was created with different permissions to resolve this issue.&...EMailing Reports From Access 06-19-07
I know this may have been asked, but after looking on the Internet, I need
some clarification...Can reports be emailed from Access? The environment
that I have is as follows...WinXP SP2, Outlook 2002, 2003 or 2007, all with
SP's applied. I would be using Leban's method of exporting the reports to
From what I've read, it's a security risk. I understand that, but I've also
seen some other things that suggest that maybe it can be done via VBA.
Any help would be appreciated.
It's a security risk only because Outlook (and other e-mai...Office 2003 Custom Installation Wizard page 10 of 24
I am setting up a MST file for Office 2003 std SP3. I am on page 10 of 24.
This is the "Change Office User Settings".
I am trying to find a Doc which shows the options in a tree layout so a can
see which options I want to disable or uses.
Does anyone know if such a doc exists?
<from memory>If I'm not mistaken, the admin pack you downloaded should have
contained an Excel spreadsheet of all the settings that can be set. (more a
less a recap of the things that can be set via a Group Policy Object.)</from
"J...Date format #10
i have a date format like this - 13.02.2007(dd.mm.yyyy)
i like to convert it to date so that i can sort it by date.
i already used the format cells to change the category type to date but
i also replace the dot(.) to slash(/) but the excel read it as mm.dd.yyyy
can someone give me a tips?
Dates are stored as numbers by Excel in a cell
Format allows you to alter the way Excel displays them.
If it was originally ente4red as 13.02.2007 then that is how it will be
stored ie as TEXT
Now when you convert the Dots to / with say Replace or manual edit
E...Outlook 2007 rules do not work 12-23-09
None of the rules I have set up in OUTLOOK 2007 will work.
General format of my rules (I start from a blank rule)
Apply this rule after the message arrives
from <people or distribution list> AND/OR with <specific words> in the subject
move it to the <specified> folder
I do not have any exceptions to my rules.
What am I missing? Why won't my rules work?!?!?
Do they work if you run them automatically? Is this on the primary mail
store? If it is a secondary mail store, do you have the rules set to run on
that .pst file as well?
Milly Staples [M...Powerpoint 2003 01-11-10
Will someone with Powerpoint 2003 be able to open and read a
presentation saved with Powerpoint 2000?
Normally. There was a problem early in the life of 2003 which was fixed in
Service Pack1 I think.
Usually later versions can open presentations made in an earlier version the
reverse is not always true.
"Sue" <email@example.com> wrote in message
> Will someone with Powerpoint 2003 be able to open and read a
> presentation saved with Powerpoint 2000?
> __________ I...Removing duplicates 10-23-07
I have a contacts table with four fields Contact_ID, Company_ID, Forename
and Surname. As a result of recent data import, many companies have ended up
with duplicate contacts, so for instance Company_ID 109 will have multiple
contacts with the same forename and surname. What is the way to remove such
duplicates such that each company is left with only one contact of a
specific forename+surname set?
On Tue, 23 Oct 2007 21:45:23 +0100, "John" <John@nospam.infovis.co.uk> wrote:
>I have a contacts table with four fields Contact_ID, Company_I...