Excel

If I have a master list of 20 part numbers in one Excel column or worksheet
how can I compare each part numbers in the master column against actual
values/part numbers in another column or worksheet, and highlight in red the
missing parts in a third column? Is there a wizzard to help me or will I have
to write a complicated macro or loop?

Hi!

Column A1:A19 = secondary list
Column B1:B19 = master list

In C1 enter this formula with the key combo of
CTRL,SHIFT,ENTER:

=IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF(COUNTIF
(A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))

Copy down until you get "blanks".

Will return:

C1 = 12A221332
C2 = 12A221333
C3 = blank

Biff

>-----Original Message-----
>If I have a master list of 20 part numbers in one Excel
column or worksheet
>how can I compare each part numbers in the master column
against actual
>values/part numbers in another column or worksheet, and
highlight in red the
>missing parts in a third column? Is there a wizzard to
help me or will I have
>to write a complicated macro or loop?
>.
>

Biff

I selected C1 and presses key combo of CTRL,SHIFT,ENTER, but was unable to
paste in the formula.

"Biff" wrote:

> Hi!
>
> Column A1:A19 = secondary list
> Column B1:B19 = master list
>
> In C1 enter this formula with the key combo of
> CTRL,SHIFT,ENTER:
>
> =IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
> ($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF(COUNTIF
> (A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
>
> Copy down until you get "blanks".
>
> Will return:
>
> C1 = 12A221332
> C2 = 12A221333
> C3 = blank
>
> Biff
>
> >-----Original Message-----
> >If I have a master list of 20 part numbers in one Excel
> column or worksheet
> >how can I compare each part numbers in the master column
> against actual
> >values/part numbers in another column or worksheet, and
> highlight in red the
> >missing parts in a third column? Is there a wizzard to
> help me or will I have
> >to write a complicated macro or loop?
> >.
> >
>

Hi!

Copy/Paste the formula into cell C1.

The formula will appear in the Formula Bar.

Goto the Formula Bar and place the cursor at the end of
the formula.

Hold down the CTRL key and the SHIFT key then hit ENTER.

If done properly Excel will enclose the formula in
squiggly braces { } which means that it is an array
formula. You must use the key combo of CTRL,SHIFT,ENTER
for it to work. You can not just simply type the braces in.

Biff

>-----Original Message-----
>Biff
>
>I selected C1 and presses key combo of CTRL,SHIFT,ENTER,
but was unable to
>paste in the formula.
>
>"Biff" wrote:
>
>> Hi!
>>
>> Column A1:A19 = secondary list
>> Column B1:B19 = master list
>>
>> In C1 enter this formula with the key combo of
>> CTRL,SHIFT,ENTER:
>>
>> =IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
>> ($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF(COUNTIF
>> (A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
>>
>> Copy down until you get "blanks".
>>
>> Will return:
>>
>> C1 = 12A221332
>> C2 = 12A221333
>> C3 = blank
>>
>> Biff
>>
>> >-----Original Message-----
>> >If I have a master list of 20 part numbers in one
Excel
>> column or worksheet
>> >how can I compare each part numbers in the master
column
>> against actual
>> >values/part numbers in another column or worksheet,
and
>> highlight in red the
>> >missing parts in a third column? Is there a wizzard to
>> help me or will I have
>> >to write a complicated macro or loop?
>> >.
>> >
>>
>.
>

Biff,

I get an error message "It says my formula is missing parenthesis. This is
the formula I copy/pasted into C1, then clicked at the end of the formula and
pressed Ctrl, Shift, Enter

=IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF(COUNTIF
(A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))


"Biff" wrote:

> Hi!
>
> Copy/Paste the formula into cell C1.
>
> The formula will appear in the Formula Bar.
>
> Goto the Formula Bar and place the cursor at the end of
> the formula.
>
> Hold down the CTRL key and the SHIFT key then hit ENTER.
>
> If done properly Excel will enclose the formula in
> squiggly braces { } which means that it is an array
> formula. You must use the key combo of CTRL,SHIFT,ENTER
> for it to work. You can not just simply type the braces in.
>
> Biff
>
> >-----Original Message-----
> >Biff
> >
> >I selected C1 and presses key combo of CTRL,SHIFT,ENTER,
> but was unable to
> >paste in the formula.
> >
> >"Biff" wrote:
> >
> >> Hi!
> >>
> >> Column A1:A19 = secondary list
> >> Column B1:B19 = master list
> >>
> >> In C1 enter this formula with the key combo of
> >> CTRL,SHIFT,ENTER:
> >>
> >> =IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
> >> ($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF(COUNTIF
> >> (A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
> >>
> >> Copy down until you get "blanks".
> >>
> >> Will return:
> >>
> >> C1 = 12A221332
> >> C2 = 12A221333
> >> C3 = blank
> >>
> >> Biff
> >>
> >> >-----Original Message-----
> >> >If I have a master list of 20 part numbers in one
> Excel
> >> column or worksheet
> >> >how can I compare each part numbers in the master
> column
> >> against actual
> >> >values/part numbers in another column or worksheet,
> and
> >> highlight in red the
> >> >missing parts in a third column? Is there a wizzard to
> >> help me or will I have
> >> >to write a complicated macro or loop?
> >> >.
> >> >
> >>
> >.
> >
>

Hi!

Should work, there's nothing wrong with the formula.

The formula is all on one line. Sometimes if you copy from
a certain source you can get messed up with line breaks or
word wrap.

If you want to send me a copy of the file I'll do it for
you. Post back with an email address and I'll contact you.

Biff

>-----Original Message-----
>Biff,
>
>I get an error message "It says my formula is missing
parenthesis. This is
>the formula I copy/pasted into C1, then clicked at the
end of the formula and
>pressed Ctrl, Shift, Enter
>
>=IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
>($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF(COUNTIF
>(A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
>
>
>"Biff" wrote:
>
>> Hi!
>>
>> Copy/Paste the formula into cell C1.
>>
>> The formula will appear in the Formula Bar.
>>
>> Goto the Formula Bar and place the cursor at the end of
>> the formula.
>>
>> Hold down the CTRL key and the SHIFT key then hit ENTER.
>>
>> If done properly Excel will enclose the formula in
>> squiggly braces { } which means that it is an array
>> formula. You must use the key combo of CTRL,SHIFT,ENTER
>> for it to work. You can not just simply type the braces
in.
>>
>> Biff
>>
>> >-----Original Message-----
>> >Biff
>> >
>> >I selected C1 and presses key combo of
CTRL,SHIFT,ENTER,
>> but was unable to
>> >paste in the formula.
>> >
>> >"Biff" wrote:
>> >
>> >> Hi!
>> >>
>> >> Column A1:A19 = secondary list
>> >> Column B1:B19 = master list
>> >>
>> >> In C1 enter this formula with the key combo of
>> >> CTRL,SHIFT,ENTER:
>> >>
>> >> =IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
>> >> ($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF
(COUNTIF
>> >> (A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
>> >>
>> >> Copy down until you get "blanks".
>> >>
>> >> Will return:
>> >>
>> >> C1 = 12A221332
>> >> C2 = 12A221333
>> >> C3 = blank
>> >>
>> >> Biff
>> >>
>> >> >-----Original Message-----
>> >> >If I have a master list of 20 part numbers in one
>> Excel
>> >> column or worksheet
>> >> >how can I compare each part numbers in the master
>> column
>> >> against actual
>> >> >values/part numbers in another column or worksheet,
>> and
>> >> highlight in red the
>> >> >missing parts in a third column? Is there a wizzard
to
>> >> help me or will I have
>> >> >to write a complicated macro or loop?
>> >> >.
>> >> >
>> >>
>> >.
>> >
>>
>.
>

Biff,

My email adderee is [email protected]
I am still having problems after I paste the formula into C1.

"Biff" wrote:

> Hi!
>
> Should work, there's nothing wrong with the formula.
>
> The formula is all on one line. Sometimes if you copy from
> a certain source you can get messed up with line breaks or
> word wrap.
>
> If you want to send me a copy of the file I'll do it for
> you. Post back with an email address and I'll contact you.
>
> Biff
>
> >-----Original Message-----
> >Biff,
> >
> >I get an error message "It says my formula is missing
> parenthesis. This is
> >the formula I copy/pasted into C1, then clicked at the
> end of the formula and
> >pressed Ctrl, Shift, Enter
> >
> >=IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
> >($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF(COUNTIF
> >(A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
> >
> >
> >"Biff" wrote:
> >
> >> Hi!
> >>
> >> Copy/Paste the formula into cell C1.
> >>
> >> The formula will appear in the Formula Bar.
> >>
> >> Goto the Formula Bar and place the cursor at the end of
> >> the formula.
> >>
> >> Hold down the CTRL key and the SHIFT key then hit ENTER.
> >>
> >> If done properly Excel will enclose the formula in
> >> squiggly braces { } which means that it is an array
> >> formula. You must use the key combo of CTRL,SHIFT,ENTER
> >> for it to work. You can not just simply type the braces
> in.
> >>
> >> Biff
> >>
> >> >-----Original Message-----
> >> >Biff
> >> >
> >> >I selected C1 and presses key combo of
> CTRL,SHIFT,ENTER,
> >> but was unable to
> >> >paste in the formula.
> >> >
> >> >"Biff" wrote:
> >> >
> >> >> Hi!
> >> >>
> >> >> Column A1:A19 = secondary list
> >> >> Column B1:B19 = master list
> >> >>
> >> >> In C1 enter this formula with the key combo of
> >> >> CTRL,SHIFT,ENTER:
> >> >>
> >> >> =IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
> >> >> ($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF
> (COUNTIF
> >> >> (A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
> >> >>
> >> >> Copy down until you get "blanks".
> >> >>
> >> >> Will return:
> >> >>
> >> >> C1 = 12A221332
> >> >> C2 = 12A221333
> >> >> C3 = blank
> >> >>
> >> >> Biff
> >> >>
> >> >> >-----Original Message-----
> >> >> >If I have a master list of 20 part numbers in one
> >> Excel
> >> >> column or worksheet
> >> >> >how can I compare each part numbers in the master
> >> column
> >> >> against actual
> >> >> >values/part numbers in another column or worksheet,
> >> and
> >> >> highlight in red the
> >> >> >missing parts in a third column? Is there a wizzard
> to
> >> >> help me or will I have
> >> >> >to write a complicated macro or loop?
> >> >> >.
> >> >> >
> >> >>
> >> >.
> >> >
> >>
> >.
> >
>

Sent an email.

Biff

>-----Original Message-----
>Biff,
>
>My email adderee is [email protected]
>I am still having problems after I paste the formula into
C1.
>
>"Biff" wrote:
>
>> Hi!
>>
>> Should work, there's nothing wrong with the formula.
>>
>> The formula is all on one line. Sometimes if you copy
from
>> a certain source you can get messed up with line breaks
or
>> word wrap.
>>
>> If you want to send me a copy of the file I'll do it
for
>> you. Post back with an email address and I'll contact
you.
>>
>> Biff
>>
>> >-----Original Message-----
>> >Biff,
>> >
>> >I get an error message "It says my formula is missing
>> parenthesis. This is
>> >the formula I copy/pasted into C1, then clicked at the
>> end of the formula and
>> >pressed Ctrl, Shift, Enter
>> >
>> >=IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
>> >($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF
(COUNTIF
>> >(A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
>> >
>> >
>> >"Biff" wrote:
>> >
>> >> Hi!
>> >>
>> >> Copy/Paste the formula into cell C1.
>> >>
>> >> The formula will appear in the Formula Bar.
>> >>
>> >> Goto the Formula Bar and place the cursor at the end
of
>> >> the formula.
>> >>
>> >> Hold down the CTRL key and the SHIFT key then hit
ENTER.
>> >>
>> >> If done properly Excel will enclose the formula in
>> >> squiggly braces { } which means that it is an array
>> >> formula. You must use the key combo of
CTRL,SHIFT,ENTER
>> >> for it to work. You can not just simply type the
braces
>> in.
>> >>
>> >> Biff
>> >>
>> >> >-----Original Message-----
>> >> >Biff
>> >> >
>> >> >I selected C1 and presses key combo of
>> CTRL,SHIFT,ENTER,
>> >> but was unable to
>> >> >paste in the formula.
>> >> >
>> >> >"Biff" wrote:
>> >> >
>> >> >> Hi!
>> >> >>
>> >> >> Column A1:A19 = secondary list
>> >> >> Column B1:B19 = master list
>> >> >>
>> >> >> In C1 enter this formula with the key combo of
>> >> >> CTRL,SHIFT,ENTER:
>> >> >>
>> >> >> =IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)
=0,ROW
>> >> >> ($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF
>> (COUNTIF
>> >> >> (A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
>> >> >>
>> >> >> Copy down until you get "blanks".
>> >> >>
>> >> >> Will return:
>> >> >>
>> >> >> C1 = 12A221332
>> >> >> C2 = 12A221333
>> >> >> C3 = blank
>> >> >>
>> >> >> Biff
>> >> >>
>> >> >> >-----Original Message-----
>> >> >> >If I have a master list of 20 part numbers in
one
>> >> Excel
>> >> >> column or worksheet
>> >> >> >how can I compare each part numbers in the
master
>> >> column
>> >> >> against actual
>> >> >> >values/part numbers in another column or
worksheet,
>> >> and
>> >> >> highlight in red the
>> >> >> >missing parts in a third column? Is there a
wizzard
>> to
>> >> >> help me or will I have
>> >> >> >to write a complicated macro or loop?
>> >> >> >.
>> >> >> >
>> >> >>
>> >> >.
>> >> >
>> >>
>> >.
>> >
>>
>.
>

My email bounced!

Oh well!

Biff

>-----Original Message-----
>Sent an email.
>
>Biff
>
>>-----Original Message-----
>>Biff,
>>
>>My email adderee is [email protected]
>>I am still having problems after I paste the formula
into
>C1.
>>
>>"Biff" wrote:
>>
>>> Hi!
>>>
>>> Should work, there's nothing wrong with the formula.
>>>
>>> The formula is all on one line. Sometimes if you copy
>from
>>> a certain source you can get messed up with line
breaks
>or
>>> word wrap.
>>>
>>> If you want to send me a copy of the file I'll do it
>for
>>> you. Post back with an email address and I'll contact
>you.
>>>
>>> Biff
>>>
>>> >-----Original Message-----
>>> >Biff,
>>> >
>>> >I get an error message "It says my formula is missing
>>> parenthesis. This is
>>> >the formula I copy/pasted into C1, then clicked at
the
>>> end of the formula and
>>> >pressed Ctrl, Shift, Enter
>>> >
>>> >=IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
>>> >($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF
>(COUNTIF
>>> >(A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
>>> >
>>> >
>>> >"Biff" wrote:
>>> >
>>> >> Hi!
>>> >>
>>> >> Copy/Paste the formula into cell C1.
>>> >>
>>> >> The formula will appear in the Formula Bar.
>>> >>
>>> >> Goto the Formula Bar and place the cursor at the
end
>of
>>> >> the formula.
>>> >>
>>> >> Hold down the CTRL key and the SHIFT key then hit
>ENTER.
>>> >>
>>> >> If done properly Excel will enclose the formula in
>>> >> squiggly braces { } which means that it is an array
>>> >> formula. You must use the key combo of
>CTRL,SHIFT,ENTER
>>> >> for it to work. You can not just simply type the
>braces
>>> in.
>>> >>
>>> >> Biff
>>> >>
>>> >> >-----Original Message-----
>>> >> >Biff
>>> >> >
>>> >> >I selected C1 and presses key combo of
>>> CTRL,SHIFT,ENTER,
>>> >> but was unable to
>>> >> >paste in the formula.
>>> >> >
>>> >> >"Biff" wrote:
>>> >> >
>>> >> >> Hi!
>>> >> >>
>>> >> >> Column A1:A19 = secondary list
>>> >> >> Column B1:B19 = master list
>>> >> >>
>>> >> >> In C1 enter this formula with the key combo of
>>> >> >> CTRL,SHIFT,ENTER:
>>> >> >>
>>> >> >> =IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)
>=0,ROW
>>> >> >> ($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF
>>> (COUNTIF
>>> >> >> (A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
>>> >> >>
>>> >> >> Copy down until you get "blanks".
>>> >> >>
>>> >> >> Will return:
>>> >> >>
>>> >> >> C1 = 12A221332
>>> >> >> C2 = 12A221333
>>> >> >> C3 = blank
>>> >> >>
>>> >> >> Biff
>>> >> >>
>>> >> >> >-----Original Message-----
>>> >> >> >If I have a master list of 20 part numbers in
>one
>>> >> Excel
>>> >> >> column or worksheet
>>> >> >> >how can I compare each part numbers in the
>master
>>> >> column
>>> >> >> against actual
>>> >> >> >values/part numbers in another column or
>worksheet,
>>> >> and
>>> >> >> highlight in red the
>>> >> >> >missing parts in a third column? Is there a
>wizzard
>>> to
>>> >> >> help me or will I have
>>> >> >> >to write a complicated macro or loop?
>>> >> >> >.
>>> >> >> >
>>> >> >>
>>> >> >.
>>> >> >
>>> >>
>>> >.
>>> >
>>>
>>.
>>
>.
>

Sorry its [email protected]

"Biff" wrote:

> My email bounced!
>
> Oh well!
>
> Biff
>
> >-----Original Message-----
> >Sent an email.
> >
> >Biff
> >
> >>-----Original Message-----
> >>Biff,
> >>
> >>My email adderee is [email protected]
> >>I am still having problems after I paste the formula
> into
> >C1.
> >>
> >>"Biff" wrote:
> >>
> >>> Hi!
> >>>
> >>> Should work, there's nothing wrong with the formula.
> >>>
> >>> The formula is all on one line. Sometimes if you copy
> >from
> >>> a certain source you can get messed up with line
> breaks
> >or
> >>> word wrap.
> >>>
> >>> If you want to send me a copy of the file I'll do it
> >for
> >>> you. Post back with an email address and I'll contact
> >you.
> >>>
> >>> Biff
> >>>
> >>> >-----Original Message-----
> >>> >Biff,
> >>> >
> >>> >I get an error message "It says my formula is missing
> >>> parenthesis. This is
> >>> >the formula I copy/pasted into C1, then clicked at
> the
> >>> end of the formula and
> >>> >pressed Ctrl, Shift, Enter
> >>> >
> >>> >=IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0,ROW
> >>> >($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF
> >(COUNTIF
> >>> >(A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
> >>> >
> >>> >
> >>> >"Biff" wrote:
> >>> >
> >>> >> Hi!
> >>> >>
> >>> >> Copy/Paste the formula into cell C1.
> >>> >>
> >>> >> The formula will appear in the Formula Bar.
> >>> >>
> >>> >> Goto the Formula Bar and place the cursor at the
> end
> >of
> >>> >> the formula.
> >>> >>
> >>> >> Hold down the CTRL key and the SHIFT key then hit
> >ENTER.
> >>> >>
> >>> >> If done properly Excel will enclose the formula in
> >>> >> squiggly braces { } which means that it is an array
> >>> >> formula. You must use the key combo of
> >CTRL,SHIFT,ENTER
> >>> >> for it to work. You can not just simply type the
> >braces
> >>> in.
> >>> >>
> >>> >> Biff
> >>> >>
> >>> >> >-----Original Message-----
> >>> >> >Biff
> >>> >> >
> >>> >> >I selected C1 and presses key combo of
> >>> CTRL,SHIFT,ENTER,
> >>> >> but was unable to
> >>> >> >paste in the formula.
> >>> >> >
> >>> >> >"Biff" wrote:
> >>> >> >
> >>> >> >> Hi!
> >>> >> >>
> >>> >> >> Column A1:A19 = secondary list
> >>> >> >> Column B1:B19 = master list
> >>> >> >>
> >>> >> >> In C1 enter this formula with the key combo of
> >>> >> >> CTRL,SHIFT,ENTER:
> >>> >> >>
> >>> >> >> =IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)
> >=0,ROW
> >>> >> >> ($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF
> >>> (COUNTIF
> >>> >> >> (A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))
> >>> >> >>
> >>> >> >> Copy down until you get "blanks".
> >>> >> >>
> >>> >> >> Will return:
> >>> >> >>
> >>> >> >> C1 = 12A221332
> >>> >> >> C2 = 12A221333
> >>> >> >> C3 = blank
> >>> >> >>
> >>> >> >> Biff
> >>> >> >>
> >>> >> >> >-----Original Message-----
> >>> >> >> >If I have a master list of 20 part numbers in
> >one
> >>> >> Excel
> >>> >> >> column or worksheet
> >>> >> >> >how can I compare each part numbers in the
> >master
> >>> >> column
> >>> >> >> against actual
> >>> >> >> >values/part numbers in another column or
> >worksheet,
> >>> >> and
> >>> >> >> highlight in red the
> >>> >> >> >missing parts in a third column? Is there a
> >wizzard
> >>> to
> >>> >> >> help me or will I have
> >>> >> >> >to write a complicated macro or loop?
> >>> >> >> >.
> >>> >> >> >
> >>> >> >>
> >>> >> >.
> >>> >> >
> >>> >>
> >>> >.
> >>> >
> >>>
> >>.
> >>
> >.
> >
>