How do I compare the stored data in micro
 

Hi,

I got four columns of stored list of addresses and dates (two for address
and two for dates) which I want to match against each other. The formats of
those columns are in example below

Column A
10 V Street

Colum B
12/16/2009

Column C
12 DEC:PTD:DEC 2009

Column D
10 V Street

I want column A and D matched as is and the column B’s first two digits (12)
and last four digits (2009) should be matched with column C’s first two
digits (12) and the last four digits (2009). If they are not the same it
should appear differently (may be red text). Any help on this will greatly
appreciated.

Re: How do I compare the stored data in micro
 

You should be doing this in Excel, not Word.

--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



"Help on formula" <Helponformula@discussions.microsoft.com> wrote in message
news:68F1E919-9697-4E24-99DC-E02B4F0D3F88@microsoft.com...
> Hi,
>
> I got four columns of stored list of addresses and dates (two for address
> and two for dates) which I want to match against each other. The formats
> of
> those columns are in example below
>
> Column A
> 10 V Street
>
> Colum B
> 12/16/2009
>
> Column C
> 12 DEC:PTD:DEC 2009
>
> Column D
> 10 V Street
>
> I want column A and D matched as is and the column B’s first two digits
> (12)
> and last four digits (2009) should be matched with column C’s first two
> digits (12) and the last four digits (2009). If they are not the same it
> should appear differently (may be red text). Any help on this will greatly
> appreciated.
>

Re: How do I compare the stored data in micro
 

This is in MS Excel. I am using Excel 2003

"JoAnn Paules" wrote:

> You should be doing this in Excel, not Word.
>
> --
> JoAnn Paules
> MVP Microsoft [Publisher]
> Tech Editor for "Microsoft Publisher 2007 For Dummies"
>
>
>
> "Help on formula" <Helponformula@discussions.microsoft.com> wrote in message
> news:68F1E919-9697-4E24-99DC-E02B4F0D3F88@microsoft.com...
> > Hi,
> >
> > I got four columns of stored list of addresses and dates (two for address
> > and two for dates) which I want to match against each other. The formats
> > of
> > those columns are in example below
> >
> > Column A
> > 10 V Street
> >
> > Colum B
> > 12/16/2009
> >
> > Column C
> > 12 DEC:PTD:DEC 2009
> >
> > Column D
> > 10 V Street
> >
> > I want column A and D matched as is and the column B’s first two digits
> > (12)
> > and last four digits (2009) should be matched with column C’s first two
> > digits (12) and the last four digits (2009). If they are not the same it
> > should appear differently (may be red text). Any help on this will greatly
> > appreciated.
> >
>
> .
>

Re: How do I compare the stored data in micro
 

Thank you very much. I was on the word forum

"Help on formula" wrote:

> This is in MS Excel. I am using Excel 2003
>
> "JoAnn Paules" wrote:
>
> > You should be doing this in Excel, not Word.
> >
> > --
> > JoAnn Paules
> > MVP Microsoft [Publisher]
> > Tech Editor for "Microsoft Publisher 2007 For Dummies"
> >
> >
> >
> > "Help on formula" <Helponformula@discussions.microsoft.com> wrote in message
> > news:68F1E919-9697-4E24-99DC-E02B4F0D3F88@microsoft.com...
> > > Hi,
> > >
> > > I got four columns of stored list of addresses and dates (two for address
> > > and two for dates) which I want to match against each other. The formats
> > > of
> > > those columns are in example below
> > >
> > > Column A
> > > 10 V Street
> > >
> > > Colum B
> > > 12/16/2009
> > >
> > > Column C
> > > 12 DEC:PTD:DEC 2009
> > >
> > > Column D
> > > 10 V Street
> > >
> > > I want column A and D matched as is and the column B’s first two digits
> > > (12)
> > > and last four digits (2009) should be matched with column C’s first two
> > > digits (12) and the last four digits (2009). If they are not the same it
> > > should appear differently (may be red text). Any help on this will greatly
> > > appreciated.
> > >
> >
> > .
> >