A function which will do the job is Frequency. You insert the number, or numbers, or ranges you want to count into a Bins array and the data you are counting into a data array.
So for your sample up there you would use something like
C1 = FREQUENCY(A1:A5;D1) and put D1 = 10.
Change the array...
I am having problems with the Junk mail filter built-in to Outllok 2003 (is it SpamBayes). I have the setting at low, and I am building up a safe-senders list. But for one or two safe senders all their emails get put into junk mail. I have checked that they are not also on the blocked senders...
Both of these actions are available via the Rules and Alerts in the Tools menu.
For example the sending message rule can be set up as:
Apply this rule after I send the message Cc the message to Dan Fretwell
This appears in the rule description with the name at the end underlined so that you...
Many thanks for the reference. It would be nice if Outlook had a built-in facility for viewing the log-files. The reference warns that the files can grow - that is so true. I have a 20-hour log with 12,657 lines. Thank goodness the problem I started with went away so I can now just delete this...
I had some problems with Outlook 2003 email and switched on logging. I'm sure I'm missing something obvious but I cannot find the logs. Does anybody know where they are?
Starting in Outlook (I haven't tried elswhere since the setting applies to all Office programs apparently) go to
Tools > Options > Other > Advanced Options > Service Options.
In the service options dialog select Online Content and there is a checkbox to Show content and links from Microsoft...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.