Thread: Trying to Create a Macro

Could someone please help me create a macro? The type of macro I want
to create is one that shows duplicates in a column. However I want the
duplicates to also show negative values. For example if there is a
value that is 425 and -425, i want them both to show up in the macro
and be highlighted. I would appreciate it so much. I am trying to
offset credits and debits.
Thanks,
Ben

here is a formula in an adjacent column that will show 2 if a match or 1 if
not. Since it is an array formula it must be entere using ctrl+shift+enter
=COUNT(IF(ABS($A$4:$A$100)=ABS(A4),$A$4:$A$100))

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
<bherrick1@gmail.com> wrote in message
news:1154033181.821550.100660@m73g2000cwd.googlegroups.com...
> Could someone please help me create a macro? The type of macro I want
> to create is one that shows duplicates in a column. However I want the
> duplicates to also show negative values. For example if there is a
> value that is 425 and -425, i want them both to show up in the macro
> and be highlighted. I would appreciate it so much. I am trying to
> offset credits and debits.
> Thanks,
> Ben
>