Subject based filtering of DSN messages
I can't make this work for the vast majority of the DSN messages we get
(message undeliverable and such). I have setup rules to filter the different
bounce messages that I see in subject lines and some of them work fine.
Most do not.
The messages the come from postfix (for instance) have mime-encoded
notification messages, split in several parts.
I've tried matching the Subject: line I end up seeing in Outlook and the
subject line that is in the internet headers of the message, which is not
what outlook shows me. I think exchange 2003 is recognizing these messages
and try...Lookup/Find help
Windows XP Professional
Hypothetical, but hopefully you'll get the gist of it:
I have two worksheets. On worksheet #1, I have two columns. First
column is a list of entire workgroup by name and 2nd column is the hours
worked. On the second worksheet I simply have an list of names that
is a subgroup of those on the first page. These indicate a target group.
Now, on the first worksheet, I want to add a third column for summing
only the target workgroup. Basically, I need a function...Can I set up a calendar lookup for date selection
Is it possible to lookup a calendar for date selection on a cell. I cannot
find any reference to it in the help.
try this url
"Tangoxray" <Tangoxray@discussions.microsoft.com> wrote in message
> Is it possible to lookup a calendar for date selection on a cell. I
> find any reference to it in the help.
...view the reference and not the value
I am trying to bring in 5 sheets a value (text) from the
first sheet. When i typing the equal (=) in the sheet2 i
saw the reference and not the value.
Any solution for that ?
i am using the XP edition
Thanks in advance Manos
1. check that your target cell is not formated as 'Text'.
change the format to 'General' and re-enter the formula
2. If this does not help goto 'Tools - Options - View' and
>I am trying to bring in 5 sheets a value (text) from the
>firs...changing lookup columns
Anybody know a way to add a column to the LookUp screen for Accounts? When I
am in a contact record and want to choose a parent account, I would like more
columns to distinguish between the different accounts that come up. This
isn't the Advanced Find or Associated View for Accounts so I can't see where
to add the columns. I've even checked the QueryBase table and don't see any
one that looks like it applies. Thanks.
There is no supported way to do this in v.1x.
Check this folder if you feel curious:
"A...cell to have comma-delimited values based on text
I have a table called "220_reference" with a column name "Part Number" having
a sample value of below:
4047122(All Dash no.), 4057222(All Dash no.), 4058222(All Dash no.),
4060122(All Dash no.)
The entire value is in one cell representing the "Part Number"
column(defined as general type so text I suppose).
Simple enough. But what I need to do is take any number that has "(All Dash
no.)" after it and search through a column in another table to retrieve any
rows that have that number(text) in it. The other table name is "220" with ...how do i semi-lock a group of cells to allow lookups formula...
how do i semi-lock a group of cells to allow lookups formulas without
allowing user changes
Do you mean you want to be able to reference these cells in lookup formulas
contained in other cells?
If so, leaving these cells locked (Format | Cells | Protection), and then
Protecting the Sheet (from teh Tools Menu) should be enough.
You may want to make sure you have Select Locked and Select Unlocked Cells
Checked, if a list of Protection Options pops up (Excel 2002 and later).
> how do i semi-lock a group of cells to allow lookups formulas without
> allo...Lookup #5
I am trying to label my bank info that I import into Excel. I have a column with the charge amount and a column with the recipient. I think a lookup table would work for this, but I need to have it check for wildcards. For example, the grocery chain is numbered here, so one might be GROCER 5454 and one may be GROCER 8724, so I need the function to look for GROCER*, right?
Also, if it does not fit any category, how can I get it to use "Other"? Do I make that one just "*"?
Mine is not working very well. Maybe my syntax is wrong.
...sum items in a table based on description
I am interested in summing items is a table based on their description. Is
there a formula that will add items together from column based on the
contents in another cell reference in the same row? I know a pivot table
will do this with some restrictions in the table design.
You can use sumif if there is onbly one condition
Assume you want to sum values in column
C where column B is "x"
"Hrider" <email@example.com> wrote in message
>I am interested ...Receive PO based on amount.
Greetings GPLings.. :)
Is there any way to receive with invoice , a PO that contain service /non
inventoried items based on the amount?
Eg: PO amount $100000000 for ONE service item and i would want to receive
and invoice only $ 200.
The reason i used this huge amount as PO is that even if i used a decimal
value to receive the PO as a percentage,it will still not be accurate as GP
allows only 5 decimal places.
In a simple form, i want to receive based on the amount rather than qty.
The only way to do that is to enter the PO for a quantity of
100,000,000 at a unit...Vendor Lookup Field with Modifier
I would like to modify the ap entry form and create 1 or 2mores field.
This additional field will be used to track related party vendor number/name
For example, the invoice is being paid to Vendor A. But because our invoice
for Vendor A may be related to Vendor B, I would like to enter this info in
the system. Currently, we just enter the related vendor ID in the note field.
But due to the large number of related party transactions, the users are
entering incorrect vendor numbers or they are not properly formatted , in the
note field. This makes it difficult to analyze related party...Join based on next closest value (like Excel VLOOKUP)
Trying to do something similar to a VLOOKUP (Excel) in an Access 2003 query.
I have the following tables:
I need a query that takes JOBS.Quantity, looks it up in COSTS.Quantity and
find the cost for the NEXT LOWEST quantity. (Example: Job B has a quantity
of 256 and the next LOWEST quantity from COSTS is 200 so Job B costs $1500.)
The results should be as follows:
This would be ...Home based Job For Indian
Want the pleasure of life, don't worry, work 1-2hours/day and earn Rs.
10,000-15,000/month online from your home/cafe/office
For details write # firstname.lastname@example.org
Please write the subject of mail as: "Job Inquiry"
...Fast alternative to table based state transition matrix
I got this answer from comp.theory. It was completely obvious once it
was explained. It is trivially simple to create a DFA based recognizer
without a state transition matrix data table. Simply encode case
statements corresponding to inputs within the case elements of a case
statement corresponding to states.
In at least some cases the (case within case) method might be faster
depending upon whether or not memory is reduced enough to more than
offset the higher case statement overhead to increase cache locality of
"Peter Olcott" <NoSpam@OCR4Screen.com...dependent combo box list, with indirect reference
I would like to create a dependent combo box.
I have a cell linked to anothe combo box, say C1.
I have one list in D1:D4, another list in E1:E3.
In C2, I have value "D1:D4", in C3 I have "E1:E3".
For the input range for the combox, I tried "=INDIRECT(IF(C1=1,C2,C3))",
but only got an empty list. Is this 'illegal'?
Debra Dalgleish shows how to do this with Data|Validation.
Maybe you could use her technique on your comboboxes.
If no, then post back with a little more info...
Comboboxes from the ...Need help getting query to reference a field in a subform
I am trying to run a query using a specific field in a subform as the
criteria. The query is displaying one combo box from the Form, as well
as several fields from its own subform.
My Form name is: FormGrantManagement
My Subform name is: TableMOA subform
My Subform's subform is: TableCostReports
The field in the subform I want to reference is: MOAID
I have found other help topics that lead me to think that a criteria
along the lines of [Forms]![FormGrantManagement]![TableMOA subform]!
[Form]![MOAID] is what I need to use, and I have tried multiple
variations of this but witho...Colouring Emails based on Headers
I am trying to use colour to pick out spam identified by a Spam program in
I have gone into the advanced settings, but can't seem to find an option to
colour based on content of the headers.
Can anyone help me out here?
Take a look at HeaderToCategory for MS Exchange 2000/2003 application:
It could help in that case.
> I am trying to use colour to pick out spam identified by a Spam program in
> an X-Header.
> I have gone into the advanced settings, but can't seem to fin...Payroll deduction based on percentage of another deduction
Is it possible to set up a payroll deduction based on percentage of another
deduction? I see we can base a deduction on selected paycodes but not
deductions. We can collect a percentage of wage attachments as collection
fees but if the wage attachment deduction amount changes each pay, we'd have
to manually change to collection fee code each pay. I'm looking for a way to
calculate this collection fee automatically.
...Row highlight based on the 1-31 day of the month
I've got a table with dates displayed in the first column (ascending order).
I would like to highlight each row based on the day of the month with one of
5 chosen colours (red, yellow, green, blue and orange).
rows with the 1st of the month: red
rows with the 2nd of the month: yellow
rows with the 6th of the month: red
You would use conditional formatting to display different colors based
upon the day value.
Your conditional formatting formula would look at the day value of the
date. You will have multiple conditions for each row.
Formula is: ...Table Lookup formula where 2 known values are inside array
I am using Excel.
Please help, I am stuck on a non-typical table lookup
I regularly use =lookup to get values where the relationship is 1:1
e.g. in a cell, I put a value, I use =lookup for that value's meaning
I need to do this, but the lookup is a table, not a 1:1 column match
Row 1 is a header, one of my search values
Column 1 is a value I want to find
the table (array) contains the other known value
I need do do a enter values in 2 cells, and have a lookup return a value
based on the value it looks up.
-- | 1 | 2 | 3 | 4
w | a | d | h | i
x | b | e | i | ...Outlook 2003
I have four different accounts setup in Outlook. I know that it is
possible to use a default signature for new messages and replies with
each account. However, when selecting New to start a new message,
naturally, it uses the default mail account and inserts the
However, when changing the sent from account in the Accounts drop
down, one would expect the "default" signature to be used; i.e.
Outlook would delete the signature that it initially inserted and
replace it with the default signature for the selected account.
This is not what happens. Seemingly, ...Chip Pearson's VB Object references
I recently distributed a 2007 workbook that contained pop up calendars
courtesy of the Microsoft Office Calendar Control 2007. I foolishly assumed
that when a user opened the workbook, Excel would “realise” that there was a
Calendar control embedded and automatically enable the VB reference.
I was looking at ways to automate the enablement of the Calendar reference
object – I found this code on Chip Pearson’s site and wondered if a similar
thing could be run to automatically select the Calendar control? This code
enables the Microsoft Visual Basic Application Ex...Missing References
I had a problem today with a missing reference - Microsoft Forms 2 on a
colleague's machine at work (Office 2003; VBA 6.5; XP).
I've read Chip Pearson's "Missing References in VBA" which is a geat
explanation about how to fix problems like this.
Oddly the library didn't seem to be flagged as "missing" and was in fact
present in the system32 directory but didn't show up in the list of
Now to the questions:
I'm not clear on whether if I write code in a project that references a
library which is not part of the &qu...Conditional Formating (how to use Offset() in cell reference)
Using XL 2003 & 97
How do enter into VBA code; the cell Offset R-12,C into
the Contitional Formatting below? (I want the "not equal to" referrence a
cell 12 rows above in the same column)
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlNotEqual,
This might help you get to the next step:
If .Row < 13 Then
'too high in the worksheet
'remove any existing format first?????
.FormatConditions.Add ...Embedded lookup
Can a lookup be embedded in another lookup? A file has separate sheets for
each month with identical formats. A file has 13 sheets, one for each month
and a YTD sheet. Each sheet has P&L data for multiple companies and the YTD
sheet has a data entry field to identify the current month. Based on the
value in that field, the lookup function should, first, go to the correct
month's sheet, then lookup the correct value. Ex: YTD Cell A1=4 for April;
All sheets Cell A3=Sales; Col B = ABC, Inc. The lookup formula will lookup
A1, go to the April sheet, then perform the looku...